Different question (this would lead to a solution to my other question): Does anyone know a way to open a saved DTS pacakge (saved to the SQL server) inside a VB Script (ActiveX in another DTS package)? ...more >>

Hi, I got this error in a Flat File connection manager, it was saying that the last column caused the disk I/O Buffer overflow, whereas the last column contains 188 characters at max. Any Idea how to deal with it ? Thanks, Fahad...more >>

Hello, I have a SSIS package that runs fine - it processes a large amount of daily data. To stress test - I'm processing multiple days to simulate more data in a single day. An "Execute SQL Task" pulls data out of Oracle into a dataset SSIS variable. Then a VB.Net "Script Task" saves this ...more >>

I have data in a SQL 2005 table that I want to import into MS CRM 3 using SSIS and wondered if anyone has tried this (or has any ideas). My first attempt at simply using the Web Service task to connect to the CRM3 web service seemed to have issues with the WSDL file. Alex...more >>

Hi, When I create a deployment utility in SSIS, it copies DTSX files to a specified directory and creates the deployment configuration file. Nothing references the Data Source Views that I have created. I am planning to import all of the packages to SQL Server, but they would not run with...more >>

Hi, I have a Flat File Source and I want to retrieve few properties of it in an Script Component. How do I? Also, How could I make the file path of Flat File Source or Connection manager dynamic or configurable through some file ? any input is appreciated. Fahad...more >>

SQL2000 lastest SPs We have a large DTS that runs every night from midnight to 2:00AM. 99% of the time there isn't a problem, but on occasion the job will be hung. There will be no messages in the event log indicating the problem, no notification since it never failed or completed. How ...more >>

Hi all - I've got the craziest situation going on with one of my DTS packages. Specifically, I have a package that includes a number of Data Driven Query tasks that hangs on one of the tasks only after the first of the month. I will run without a hitch from about the 6 or 7th of a given month ...more >>

I am new to SQL Server and would be greatful for any assistance you may be able to provide. I have an incoming directory that recieves .csv files are regular intervals. I need to be able to identify when these files arrive and then load them into SQL Server into seperate tables overwriting the...more >>

I am new to SQL Server and would be greatful for any assistance you may be able to provide. I have an incoming directory that recieves .csv files are regular intervals. I need to be able to identify when these files arrive and then load them into SQL Server into seperate tables overwriting the...more >>

If I execute the following command in a DTS package will the rows be inserted in that order? SELECT * INTO TableB FROM TableA ORDER BY COL3, COL2, COL5 And when I perform the following select statement would they still be sorted in that order? SELECT * FROM Table...more >>

Hi, This error is driving me crazy. I am trying to add the following SQL statement in a transform data task under the source tab. SELECT loc_id, ( select convert(varchar(9),dbo.wkending(max(weekending) ),112)from dbo.archive where loc_id = loc_id ) weekending, quantity, ...more >>

I have developed a VS C# program that retrieves data from a 3rd party web service, then store the data in a SQL database. I've schedule the application to run on a pre-determined interval (say 5 minutes) using Windows Scheduler, so it gets new set of data each time. All is well. However, ...more >>

I need RDB ODBC to use in my SSIS projects. is there any????...more >>

I am trying to run a stored procedure from an SQL task: First, here is the proc (execs fine in : SSMS query) CREATE PROC [dbo].[sp_Hist_Max_Dates] @Interval varchar(8), @Name1 varchar(32), @Max_Date datetime OUTPUT AS IF @Interval = 'd' BEGIN SELECT @Max_Date = MAX(Max_Dai...more >>

Hi: I have an Execute SQL Task that takes input paramters and then is to set one datetime variable as the output parameter. For the output paramter there is no "datetime" variable type, only DBDATE and DBTIME. When I execute the task I get an error saying that it is the wrong datatype. My dat...more >>

Hello all, When ever importing from Excel using the Import/Export Wizard, when you get to the part where you select the sheets you want to import, what shows up in the list is something like: '[1st Sheet Name]$' '[1st Sheet Name]$_' '[2nd Sheet Name]$' '[2nd Sheet Name]$_' ....etc W...more >>

I'm running into some issues trying to install SSIS. Here's the scenario: We've got SQL Server 2K5 running on Windows Server 2003. When the server was initially set up. they failed to install SSIS. They then applied SP1 to the box. I have been trying to install SSIS now SEVERAL times, and ...more >>

Hi, Can any one help me to insert data into excel file from a webpage.. My database is in the form of excel file and the data comes from the ASP page. so can any one help me with the code. Thanks ...more >>

I am trying to set the connection string in a connection manager at runtime. Here is what I have done: 1. Created a gv_DataSource, gv_Username and gv_Password 2. Created a ForEach Loop that reads DataSource, Username and password values from a variable (it is an For Each ADO loop Enumerator)...more >>

Hi I'm running sql server 7 and while entering/changing activex scripts when creating a new package, I find that sometimes changes are not saved. This is annoying obviously. I will make change to the script, "save" it and try executing and error out, then call it up again and find that it...more >>

I have an OLEDB Source with a sql statement "select * from myTableFN(@param)". It doesn't seem to matter if I use SQL Native connection or OLEDB, doesn't matter if I present the parameter as "@param" or "?", the parser can't find a parameter. When I click on the Parameters button on the OLEDB ...more >>

When I copy and paste an object (ex. "execute SQL Task") inside the designer, the entire work area gets shifted down and to the right 1/2 way off the screen. Is there a trick or tweak to this? Does anyone else experience this? Is this is a fixable problem? It's weird, and only annoying, ...more >>

I have a DTS Package that I am trying to execute from a VBA program, but I think the order of the tasks in the package might be getting confused. I have 4 parts, and in this order: SetVariables using DynamicProperties DeleteLoadData using ExecuteSQL LoadData using a transfer from a text file...more >>

Hello, I've got a spreadsheet that I am exporting data to. It works great. I export the data and then send it in an email. Now the team wants me to insert the process date into the spreadsheet before I email it. The process date is a global variable in my DTS package. I'm not sure h...more >>

I am working on a data conversion job. I have imported my base data. I now want to change the value in 1 field in a subset of rows. I would like to use a text file or an XL file to control the changes that I need to make. For instance: Imported Row: Item# Sell Date 1 ...more >>