Hi, I am exporting data to a worksheet "Data". The worksheet "Result" is based on the worksheet "Data", and has a pivot table. When my users open the workbook, the pivot table gets refreshed which changes the state of the file to "modified". When they close the workbook, they get a messa...more >>

Hi All, I open a new project and select Business Intelligence Projects, but i don't see Data Transformation Project? I am using VS2005 prefessional edition and Microsoft SQL Server Management Studio version 9.00.1399.00 Thanks Nick...more >>

I have my packages organized into Solutions and Projects. When I click the Start Debugging button on the toolbar, it starts up ALL PACKAGES FROM ALL PROJECTS in the Solution. In other Solutions, clicking the Start Debugging button only starts the one package that is open at the time. Wha...more >>

I want to do a simple DTS export of a database. From a SQL 2005 database, export it to Access or Excel (both 2003) I'm running on Windows Server 2003 SBE I create a blank Access/Excel file and am unable to export to either Access or Excel. The DTS Errors I recieve when exporting to Exc...more >>

Sorry if this isn't the right place for this but I got this problem dumped on me, and I'm more of a mainframe guy. We have a package that each week uses HTTPS to log onto a secure website and download 3 files. I then unzip these files and run a SQL2000 DTS package which drops a bunch of tables...more >>

Hi, I have a dts package which contains serveral steps and recently it has been failing in one of the steps. Is there any way I can trace why it fails? Thanks,...more >>

Hi, I have a dts package which contains several steps, Is there any way I can view what exactly each step does---the code for each step? Thanks, ...more >>

Hello, I have a series of fixed width flat files where the character length of each record is 384. The problem is that there is not a carriage return after the ends of some of the records. There is research under way to find out just exactly why this happens, but in the meantime, I need to f...more >>

Hi, is it possible to split data (Space Separated Values format) in a column into several rows? I have a datasource/data extraction where a column has multiple values separated by space. Those values should be in a row record by themselves. I was planning to connect the data to Script Comp...more >>

Is there a way to execute a single DTS task using VBScript in SQL 2000? TIA, Alex ...more >>

After installing sql server 2005 as second instance on top of 2000 instance the dts package with ActiveX Script in 2000 instance hangs on execution Does anyone experience such problems Any solutions Thank you, ...more >>

Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does...more >>

How does one supply parameters to the SSIS call when using a .NET assembly? The code snipet I am using allows me to call a SSIS package, but I do not know how to supply a parameter value for a SSIS package variable defined in a package configuration with a parent package variable. Here ...more >>

i want to dynamic dts package on dotnet i can working on data from dynamic txt file to table in sql server .but txt and table name is changeable. can i do in vs.net ??(C#.Net) ...more >>

Hi everyone, I am using a flat file connection within my SSIS package to importing a .csv file containing double quotes (") as a text qualifier. The problem is, that some rows contain not only strings like "test" but also strings like "test". Debugging the project results in the error : The co...more >>

Hi everyone, I am using a flat file connection within my SSIS package to importing a .csv file containing double quotes (") as a text qualifier. The problem is, that some rows contain not only strings like "test" but also strings like """test""". Debugging the project results in the error...more >>

I am trying to write a Windows Script file that will update an exisiting DTS package. The objective is to add an additional mapping to the single transformation in a DataPump task. The existing transformation maps many fields, and I'm just trying to add a field to the list. The code I...more >>

Hi there I have a DTS package that will take records from a log file, insert them into a staging table, which is a real table in SQL. Then I want to insert these records into another results table which is a table to be used in a web application. How do I check, without using a cursor, if the...more >>

Hi I created at SSIS package in BIDS where I use the WMI Event Watcher to lookout for the creation of a text file, when I run the package from BIDS it works fine. Now that I'm done, I created a SQL Server Agent job with the package as a step, but when it "run" the job, it does nothing - no er...more >>

Hi, I had a dts package running fine on a sql server 2000 instance. An ActiveX component of that package stopped working when a 2005 instance was installed on the same server - but the package was still running on the 2000 instance. The script is just create a text file on a server. It r...more >>

I have a DTS package I created that is dadabase driven to process source data from multiple sources. Can I run several instances of this package in parallel for each source or would I need to create a copy for each source ? JavaWaba ...more >>

Hello, I would like to be able to pull daily main frame files into my SQL database on a daily basis. We have the code down in order to get the files from the mainframe, where we are struggling is with a DTS task to check and see if the file is for the previous day and then if it is, execut...more >>

I am trying to desing a series of SSIS packages that will read their Connection Manager's connection string property from a package configurtion. I anticipate databases migrating between servers in the near future and do not want to re-design or re-enter connection strings, etc. I set up a sin...more >>

I'm trying to implement an SSIS package but have run short of ideas on how to best do it. I need to send a group of uniquely named data request scripts (with file extension .req), to an FTP location. After a short (but unknown) length of time, a similarly named data file will appear at the ft...more >>

The scenario : I import a medical history table every day. If I delete the destination data table every day and import the complete table, it takes a hell lot of time (about 2 hours). I just want to import the refreshed(or new data) and not the old data. Let me explain with an example, say if ...more >>