Hello. While I found several Excel destination posts similar to mine, I didn't see one with my particular issue. Within the SSIS designer I have a simple data task with a two ForEachLoops. The first foreach will write to my Excel Destination's first two columns. The second foreach will c...more >>

Hi, I have package on a single server. This packages extracts Data from System A and loads System B, database C. What I'd like to do is use configurations to have this one package loads System B, database C and D. When a I create two configurations (one pointing at database C and...more >>

Hi, I have a SQL 2000 DTS package that I saved as a .bas file that I need to import back into SQL server. Does anyone know how I can do this? Thanks! Kevin...more >>

If you use a File Watcher task to watch a folder for files added and 1000 files get copied to that folder, does the package try and run 1000 times in parallel? I want to build a process that will import files one-at-a-time and get started when a batch of files arrives in the source folder. ...more >>

Hello all, I'm trying to test a column and return a date calculated from the columns value or leave the field/column as NULL Here is what I was trying (based on ActiveX scripts in DTS, this would default to NULL when tested false): If Row.OpenDate <> "00000000" Then Row.oOpe...more >>

Hello all, I'm quite new to SSIS packages, so I don't know how to debug them very well. I have a Flat File Source, a Script Component, and an OLE DB Destination. When I run it, it looks like it is trying to import rows: "9,916 Rows" shows up on either side of the Script Componen. And the...more >>

Dear all, I am trying to import some data from Excel to SQL 2000 table. There is a column which contains integers, before the data import, I changed the cell format of the whole column to "Text". The data type in the sQL table is char already. However, some cells values are still not import...more >>

I am using SQL Server 2000 DTS Dynamic Properties Task to set my Connections via global variables I set with a vb application at runtime. This has been no problem about half the time. I can verify that the variables are being set, but half of my DTS's setup this way either import no data or ...more >>

I'm using an ODBC data connection to an informix database. The ODBC is my source and SQL is my destination. In the data pump, I can query the data using literals in the where clause for a date range, but when I try to use a variable, I receive a ODBC/Informix syntax error. I need to extract...more >>

I downloaded and installed the Microsoft .NET Data Provider for mySAP. I have pointed it at internal SAP instance. When I attempt to execute a task using this provider I receive the error saying that Z_EXTRACT_DATA_FULL could not be found. This looks like a custom BAPI or remote function mo...more >>

Tried BOL, Live Search, Google, <Find> here... Receiving a periodic data file with date/time post-pended to the same filename ... e.g.: FileName20070607 FileName20070608 FileName20070609 ... Looking for a way to schedule a periodic import of the data within the files. Co...more >>

Hi there, I have created a DTS package that works fine when you execute it, but when you schedule it, it will always fail. The package connects a local SQL server to a remote web server that also has SQL 2000 running on it. Its running in Windows only security mode. The package deletes the...more >>

I am checking the size of DAT file using script task and if it is Zero I am returning that step as Failure "DTSTaskExecResult_Failure". On Failure it should proceed to next step and skip the present step. But this is not working and the package is getting error out. Can anyone pls guide how...more >>

How could I get the full path of the .dtsx file in the Script Task? -- Thanks. Daniel...more >>

Hi, I am trying to import data from excel into a existing table, but the import wizard doesn't appear to give me that option. Can any help me with this? ...more >>

Hello, I'm trying to use SSIS to import a flat file into my db. However, I want to also insert the date the flat file was created. I want to use the script task, but I'm new to VB.Net. Can someone please tell me how to do this? I've already spent over 12 hours trying to get it work...more >>

I have set up a SSIS package consisting of OLE DB Source - Legacy Customers Table OLE DB Destination - Valid Customer Table OLE DB Destination - Exceptions Table Against the OLE Db Source , I have specified a Redirect Row on all columns when Truncation occurs. The OLE DB Source E...more >>

I took over some SQL work and I need to rename an connection object in a DTS package. Is there a way to rename this object without recreating the entire dts package and still have the package still work? ...more >>

Hi, I am playing for the first time with this component. I designed a very simple transfer data from sql table to a raw file destination. I tried to read the file with raw file reader, I can see the headers but not the raws. Is there any information /articles about using/debuging raw file comp...more >>

Hi, there, I am creating a job, which will run a DTS package (SQL 2000), Due to the way it set up, I need to pass the IP address as the server name, for example, say the IP address is 64.84.50.11 User name is sa password is webpass package name is datadump1 I used the command ...more >>