I have been following Darren Green's excellent article on executing DTS packages from SPs... I am stuck now though, I have everything working great,...

Joe

11-14-2008 11:50 AM
Joe

I have a table called MemberRnrollment, which contains two columns, EnrollmentDate and Enrollee. I need to create an SSIS to send me the total...

qjlee

11-13-2008 08:57 PM
qjlee

A DTS package that inputs a flat file. The file's name is set using dynamic properties task. I need a task to detect if the file is empty and...

Mike

11-13-2008 03:23 PM
Mike

Can I read each individual row in a flat file using integrated services, each row is fixed position and some rows contain a different amount of...

Joseph

11-12-2008 01:26 PM
Joseph

Can I read each individual row in a flat file using integrated services, each row is fixed position and some rows contain a different amount of...

Joseph

11-12-2008 01:24 PM
Joseph

I have some DBFs that i created from foxpro. How can I DTS them into a sql table? Ive never done dts before so a walk through would be nice. ...

LearningVisualC2005

11-12-2008 08:53 AM
LearningVisualC2005

Hi i am getting the next error : SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is...

eyalso@gmail.com

11-11-2008 09:17 AM
Todd C

Hi, I have very poorly designed DW and OLAP environment and am having problem with different behavior of default sorting order on database View in...

CJ

11-07-2008 09:28 AM
CJ

When designing an SSIS package data flow, I can see an XML Source but no XML destination, am I missing something or if this is a limitation of SSIS...

pxb

11-07-2008 09:28 AM
pxb

Could anyone please assist? I need to have Autofilter on a Protected Excel worksheet, but I can't seem to get it working. I know the same thing can...

JL

11-05-2008 05:58 PM
JL

I created a simple package that just doesn't want to run regularly. It's simply an FTP download and overwriting a single file in a directory. I...

Rockitman

11-05-2008 02:22 PM
Rockitman

Has anyone been able to get the DTS designer to work in the 2008 management studio? I had it working in 2005 SSMS, now it will not work in either...

Bruce

11-03-2008 04:46 AM
Davide

Hi, I am a DBA. We deploy SSIS packages on MSDB when a migration request comes from the developers. The config file is on a file system. The...

Uma

11-03-2008 03:18 AM
msnews.microsoft.com

I upgraded our SQL Server 2005 sp2 installation to SQL Server 2008. The installation is a 32 bit install on a 64 bit Windows Server 2003 R2. ...

TomM

11-03-2008 03:02 AM
Mark Han[MSFT]

In a Dataflow task, aside from the built-in Excel Destination, is there any other options for Excel support that provides richer functionality? Such...

pxb

11-02-2008 11:18 PM
pxb

I'm new to SSIS. When i used SQL 2000 and DTS, I was able to call a DTS package from a stored procedrue. Can I do the same with DTSX or SSIS...

Mr Not So Know It All

11-02-2008 09:20 AM
Mr Not So Know It All

I have DTS package which is scheduled to run every day and imports the data from Web server log files into Database which is on another server. This...

nitin.narang01@gmail.com

10-31-2008 03:27 PM
nitin.narang01@gmail.com

how can i accomplish that i can work with multi user on one ssis/bi projekt? specificaly regarding dimensions and cubes. is visual source safe the...

Moby

10-31-2008 10:19 AM
Moby

Hello Everybody, I do have question abt archive and deleting file from remote server using SSIS. I have one database server (payrollproduction) where...

mvp

10-31-2008 09:01 AM
Todd C

Hello, Iam trying to pass parameters to Oracle via SSIS data flow task but Iam getting "Invalid SQL command" Oracle error. This is what I have...

msnews.microsoft.com

10-31-2008 07:56 AM
Todd C

I have an SSIS package which uses an OLE DB connection to a SQL Server 2005 database. It then runs a script component to manipulate the data...

Peter

10-29-2008 04:10 PM
Peter

I am trying to export data to an Excel file from from SQL Server Integration Services (2005). The details of the error I'm encountering are...

Craig Stewart

10-29-2008 04:03 PM
Craig Stewart

SQL 2000 I can not open any of our DTS packages. If I go to design package, I get the following error: Error Desc: DBNETLIB ConnectionRead recv...

Anonymous

10-29-2008 03:02 PM
Anonymous

Hi, I have a control flow, at the end i'm trying to send a very big file (a zip). Because we have some network problem, i would like to try it until...

MIB

10-29-2008 08:58 AM
MIB

Ok, So here is what I have. I have 2 different sql queries that need to go into the same flat file. What I've done is created a dynamic variable...

richard.hunt

10-29-2008 08:43 AM
richard.hunt

When we try to import data from an excel, we are getting an error 'data for source column <column name> is too large for the specified buffer...

Augustin Prasanna

10-28-2008 11:52 PM
Augustin Prasanna

using an ODBC dbf connection in the import/export wizard, I am finding that I am unable to use traditional SQL syntax in the "Provide a Source...

Matthew Wieder

10-27-2008 12:45 PM
Matthew Wieder

How would I go about creating an exact replica of a dBase file as a SQL table? Using SSIS, I can create the data source from the dBase file, but...

Matthew Wieder

10-25-2008 09:27 AM
Todd C

I have created a DTS package on my TEST server in SQL 2K. I want to move this package to PROD. I cannot script and hand over it to my DBA. What is...

Giri Palakodeti

10-23-2008 03:22 PM
Russell Fields

I have created a dts package where in which I am pulling a data from sql server to excel. before doing this I have used a activex script to run a...

sandeep chandrashekar

10-23-2008 10:55 AM
sandeep chandrashekar

I want to create a DTS Package to pull data from an Oracle table into a SQL2K table. How can I insert rows that are not already in the SQL2K table...

Rokal

10-22-2008 10:11 AM
Rokal

I have a DTS package with an Excel spreadsheet as the source and a text file as the destination. There is a transformation that occurs on the data...

Bird Byte

10-21-2008 11:08 AM
Bird Byte

In my package, i'm using an DSN connection with a password to DB2. When the package is running on my PC, every thing is working very well. But when...

MIB

10-21-2008 08:53 AM
Todd C

I have a .dtsx that I originally created in VS2005. I would like to get the designer of VS2008 to be able to edit the code so that I can maintain...

michael

10-21-2008 08:49 AM
Paul Shapiro

Hi, I have an SSIS Package which I build and deploy to a Database Server where I schedule it to run daily. When it runs it uses the Connection...

C

10-21-2008 08:46 AM
Todd C

Hello, Iam trying to execute the below query against Oracle OLEDB Source in a data flow task: select frq_code, frq_name, update_frq, ...

msnews.microsoft.com

10-21-2008 04:30 AM
msnews.microsoft.com

I'm using bcp command to export a sql server table to an excel sheet. I've created a bcp format file to use with the command. It looks like this...

pensio

10-19-2008 10:52 PM
Mark Han[MSFT]

Hello, Someone sent me a cube file. I restored it and the cubes work great. Can someone please tell me how I can save the online cube to a project...

Jason

10-19-2008 02:55 PM
Jason

Hi SQL server experts, I tried to import a text file which has a row that has a column of value 222945700 This value is imported into an INT column...

Pingx

10-17-2008 05:21 PM
Pingx

Hello Gurus, Enviroment: SQL Server 2000 SP4 Build 2187 Windows 2003 SP2 Receiving the following error Microsoft Excel Open method of Workbooks...

FredG

10-16-2008 10:19 AM
FredG

I am working on migrating a database for SQL 2000 on a Windows 2000 server, over to SQL 2005 on a Windows 2003 server A large amount of the data in...

Irvine, Dennis

10-15-2008 10:39 PM
den

Currently I have two SQL servers that need SSIS packages run against them to upload data from excel or access. The preferred method is to have an end...

Dwight

10-15-2008 07:14 PM
Irvine, Dennis

I am trying to recreate some fairly simple data exports that I had in 2000 DTS packages. I created them by using the data export wizard and...

Nathaniel

10-15-2008 01:33 PM
matteus

Hi All, I would like to convert RecordSet to comma separated values in my SSIS 2005 package. I populate a recordset usinq a SQL task: (select...

Pasha

10-14-2008 03:21 PM
Pasha

We have a data feed from our SQL Server 2005 Datawarehouse that is feeding data to Oracle 10g. This feed had been working great for several weeks...

jwall76

10-14-2008 08:41 AM
jwall76

We have a data feed from our SQL Server 2005 Datawarehouse that is feeding data to Oracle 10g. This feed had been working great for several weeks...

jwall76

10-13-2008 01:12 PM
jwall76

Newby here: Where do you do VB Transformations in SSIS? Like...

robboll

10-10-2008 12:24 PM
Todd C

I am running an SSIS job from a VB.NET application by calling sp_start_job. The return value I get is only whether or not it was able to start the...

Steve Jensen

10-08-2008 02:16 PM
Sony A

Hello, I am trying to build a solution that extracts data from some large SQL Server 2005 tables to MS Access databases on a regular scheduled...

hfdev

10-08-2008 11:02 AM
hfdev

I have a UTF-8 encoded comma delimited file. If I try to load that into a table using an OLE DB Destination. It goes in as Code page 1252...

Brad Deem

10-07-2008 06:50 PM
Brad Deem