Hi, I am quite new to SSIS but inherited a package written by my predecessor to maintain. The SSIS Mater pckage runs nearly 6 to 7 DTS packages within it. DTS Package A was one of the child packages run within the Master package. This package A is available in the Legacy folder in the SQL 2...more >>

Hi, I have a batch file, copies a xls file for one dir to another and delete source file. This works in DTS package, but when I schedule the package, it fails. Any help in ver much appreciated....more >>

I would like to run a ssis package and pass the filename as the parameter to the package. This is what I have worked out so far but notice the error message: xp_cmdshell 'dtexec.exe /f "d:\sysappl\CEM\SSIS\Imports\Trades\CounterPartyExposureEquitiesImport.dtsx\EqRonnieHK.csv"' p.s. If I r...more >>

Hi, Using SSIS, how is it possible to execute another ssis package and pass a parameter to it? For example, I would like to have a sql code that runs the package say "d:\sysappl\CEM\SSIS\CSA.dtsx" and pass a parameter of fileName because the CSA.dtsx package requires a filename. Something...more >>

Can I call an SSIS Package from a Stored Procedure?...more >>

Hi, Using SSIS, while importing (source i.e. .csv into destination i.e. sql server table), how is it possible to log the source COLUMN which causes the error in the row? Thanks...more >>

I've got a delimited text file that aprox 5.5GB that I'm trying to load into a table on SQL 2000 (Windows Server 2003) and I keep getting the error "Not enough storage is available to complete this operation." Changing the commit size doesn't seem to make a difference, but when I changed a co...more >>

(Re-Posted from another site with permission, since I have the same problem and he stated the issue well:) -- David Walker Kirk Shanks Uploading Text File with Header and Trailer Records I have bunch of records to upload that has trailer and header records from which I need to c...more >>

I am having trouble with the pivot transform. My desired results are not quite like the examples I have seen in the Help, and I am wondering if the pivot transform is the right tool to use. I have source data that is similar to the following: Customer BankName BankRole ABC C...more >>

In SSIS, what toolboox item can I use to pull the disinct rows from a flat file that has repeating data. I am trying to do this without importing the data into staged table then use tsql to pull distinct values and load the production table -- BrettVP...more >>

SQL Server 2000 SP4. I built a large DTS package that grabs a number of tables from an Oracle DB, does some scrubbing, updates, and date verification and loads to a SQL Server DB. Most of the tables are full refresh and a few are incremental. Main DW: DwSQL Staging Area: DwLoadAreaSQL ...more >>

I am running SQL Server 2005 and trying to make a copy of a database from Management Studio. Using the Backup wizard I go through all the steps that you would normally walk through to make a copy, and actually start the copy, but when I do I get the following error message from the copy datab...more >>

Hi, I am using a foreach loop to go through the .txt files inside a folder. Using a variable I can pickup the filenames the loop is going through. At present there is a sql task inside the foreach loop which takes the filename as a parameter and passes this filename to a stored procedure. Now ...more >>

Hi, I am going to use the SQL Agent to schedule my SSIS Job. However, I only want my SSIS Package to run if a flag in a table has been set. This flag is set by another job/process which someone else in my company developed. Can I set up my job within SQL Agent to check this flag? If...more >>

I'm Using a VB Script (ActiveX Script Task) to create a connection and a = recordset to a specific database in the local server. I dont want to name the server explicitly in the connection string = because the DTS package would be installed in another server with = another name. How could I ref...more >>

I last developed SSIS in Oct 05 and this bug was a major irritant. 18 months later I'm revisiting the same deployment and it's annoying me all over again. I'm wondering if one of the service packs has fixed it in the meantime? Thanks in advance David...more >>

I create a Execute task that sets a boolean value of whether or not to continue the processing of the package How do I evaluate that variable to determin whether to continue of fail. In DTS I would have written and ActieX script and giving it a status code but I do not see the same function in...more >>

Background of the problem I am encounting: In a SQL 2000 DTS package, I created a ActiveX script task with the following code (simplified version). I want to copy a string and paste it to the clipboard, and this task is executed as the last step in the package. The problem is when I execute...more >>

Hi, I have a SSIS Package that uses SQL Server to store the config data. When the package executes I get these warnings (16 of them) there are 8 config keys. If there are 14 config keys there are 28 warnings. In Visual Studio they are printed in chinese! I have deleted the config and re ...more >>

I have a server that had SQL agent working on it, and running scheduled jobs on set interval forever. Windows Server 2003, SQL 2000, most current service packs on both. I installed an instance of SQL 2005 on this server. Now, when I look at Enterprise Manager & try to see what's happening ...more >>

Hello, I have a Pipe ('|') delimited Flat File having Nested records into it. Can I handle i.e. pull data from such files into SQL Server using SSIS? The Flat File is as follows: ------------------------------------------------------------------------ BHR (1) Batch Header Record PRD (...more >>

Hi is it possible to set *.TXT;*.DOC;*.XLS in the files: textbox i Foreach Task Component ...more >>

i have a table that contains historical data. i need to process records by business date, i.e. run package for date 1, then for date 2 etc. any suggestions on how to approach this?...more >>

Hello everyone. I have a package in DTS that I am tryinig to work with. We have a few queries that will export the same exact table to a text file. I am trying to make it so we can pull a previously created text file from a central "CommonFile" folder. In this package I have a Execute Pack...more >>

hi, how can i get into the package the user.variable i passed by the command line : DTEXEC /SQL "\aaa\packages" /SERVER SQL2005SERVER /SET "\Package.Variables[User::myvar].Properties[Value]";5849 i write this activeX script a = Ctype(Dts.Variables.[User::myvar].Value, String) and also a...more >>

hi, in sql2000 I used "dtsrun" to run a DTS package from a stored procedure and used the /A parameter for passing user variables. How can i use the "SSIS" to build into the SQL2005 server a new package and run it from a stored procedure while passing user variables. thanks....more >>

Hello, Currently we are a SQL-Server 2005 Standard Edition SP2 (build 3042) and wish to copy a datebase using the Copy Database Wizard. Unfortunately, this does not work on build 3042 we receive the follow error. And this error only occurs when we try to copy a database with more than 500 (...more >>

what difference does it make if want to execute t-sql statements dritectly in the process task icon in the dts rather than creating a Stored procedure and executing it in the process task icon Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Hi, I've a file which I'll download from my client's site and save it on my hard disk, and import it to the same database table every friday. I want to make this process automatic. So, I went online and searched on this issue. And I'm pretty much convinced that DTS could do this. I went and ...more >>

I am using a DTS package to update some tables in an online database and have run into trouble with one of the tasks. The SELECT I'm using is; SELECT DISTINCT d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE, d.ACCOUNTRELATION, d.AMOUNT, u.TXT FROM PRICEDISCTABLE AS...more >>

Hello, I am having a bit of trouble with SSIS Configurations. - In BIDS, I have added a configuration file and specified the properties I want to expose. - When I build the project, I get the standard bin\deployment folder which contains the package file (.dtsx), the configuration file (....more >>

Hi, Every month, i need to upload a set of raw data to SQL. the raw data format is mm/dd/yyyy 10:59:00 AM. I want to standardise the date format in SQL to only mm/dd/yyyy without any time indication. How to change the date format in the SQK to mm/dd/yyyy and how to convert the raw data date...more >>

Hello! I'm Creating a DTS to export information into a VFP table but first a need to delete all existing data from VFP table I'm using a conecction "Microsoft OLE DB Provider for Visual Fox Pro" between SQL server 2000 and my VFP free table called "ValidStores.dbf" and i can view data from ...more >>

Hi, I try to import a text file into sql server table which has combination of string, int, float, datetime fields. Some how I keep getting error with data conversion from String to Int, String to Float, String to DateTime fields. How can I overcome this problem? I though SQL handles thi...more >>

It seems to me that SSIS packages changed creately fromt he DTS that I used to know. So my question will seem rather simple. How do I get a variable into an sql query that transfer data from 1 database to another. Old Query would be: Select FirstName, LastName FROM Person WHERE Locatio...more >>

Hello all, What's the trick to use a Foreach File in Folder loop when looping through Excel files? I've gotten the loop to work with flat files before, but doesn't seem to like Excel files. I have 36 XL spreadsheets (one for each month over a time series) that need to be imported into o...more >>

Hello, can anyone suggest info on how to create a custom log provider for SSIS? In particular, I want to track the row count and duration for each Execute SQL Task and Dataflow Task. I've seen an example of logging using event handlers at http://blogs.conchango.com/jamiethomson/archive/2...more >>

Is it possible to deploy and view SSIS packages as DTS in sql 2005 EM legacy components.? ...more >>

Hello All, OLE DB Source executed an SP to retrieve data. Trying to send the output to Raw File. When editing the raw file task, "This component has no available input columns". When trying to save/close the edit window, "There is no selected column to be written to the file". Are ...more >>

Hi Chaps, I am developing a DTS package to import data from a remote Oracle database into our SQl Server 2000 database. The connectivity to Oracle is fine and I can browse all tables and preview them via the preview of a transformation task. Instead of a Table/View in the Source tab page, I...more >>

Here's the scenario: 1) Customers enter an image request on a website (free-form textbox) 2) A record is entered in the database as an image request (with corresponding pointers for identifying the customer, datetime, etc) 3) The customer actually included several unique items in a comma-sepa...more >>

Hi Guys, I'm currently using SSIS to copy data from a source table, change some of the datatypes and pump it into a destination table. The problem I'm facing is with conversion of an NTEXT field to a VARCHAR field in the destination. What I'm doing right now is: Step 1: Extract From So...more >>

i am trying to find a way to calculate record hash something like crc in order to identify if record send to me is a modified record or not. for example i have a record that has employee id, name, phone(in reality i have to deal with tables that have over 200 columns). so if i have a way to ...more >>

Our team should migrated all SQL 2K DB's to SQL 2K5 x64 (64-bits version). As part of migration we should migrate DTS packages. Almost DTS's are simple, have not level of complexity. We're following next steps to migrate them: 1. Connect to SQL 2005 server using SQL Management Studio from th...more >>

Hi Need to migrate all DTS packages from SQL2000 to SQL2005. May i know how to do it effectively. Also, to ensure all the transformations in the DTS are intact. Thank you Best regards Michelle...more >>

Hello I am using Copy SQL Server Objects Task to copy tables and data from SQL server 1 to SQL server2, replacing the tables and data in SQL server2. Is there a way to automatically check if all the tables I am copying in SQL server1 have data before copying? Thanks, Q...more >>

Greetings SSIS gurus ... Is there some way that SSIS projects can recognize a drive mapping when the package(s) are executed from within a SMS job ? The SMS job agent runs within it's own shell and I've tried using " EXECUTE xp_cmdshell 'SUBST W: \\network_server\shared\database\sql_serv...more >>

I want to skip running the SSIS data flow task when the source file is missing. We have a scheduler that copies the source file to the staging area. This SSIS package runs as SQL server job. So when a SSIS package fails due to missing file the remaining steps in the SQL scheduler won't execut...more >>

hello, how come when I debug the package I'm working in, all of the packages in the solution are opened? How do I prevent this from happening? Thanks, Jason ...more >>

Hi, I am running a dts package. Where can I find the log of the dts package just run. I am curious to see the log of the dts package especially if there are errors that will prevent all data to be imported. In that case I will be able to analyze the errors for the data that does not get impor...more >>