I am attempting to import data from a Oracle XE source into a SQL Server 2000 instance. I have imported from Oracle 9i and 10g, using the OLE DB Provider for Oracle. I specify the server name, XE, I get an error when I test the connection. "Test connetion failed because of an error in in...more >>

Hi all, I am trying to import an csv file into SQL table, but I am having error with float (integer), and date fields. String fields are ok. Isn't that SQL takes care of these conversion automatically? If I have to convert data manually, how can I do this, and what syntax? Anyone ha...more >>

Hi, first of all, let me state that I'm new to SSIS. I've been successfully using DTS for quite some time, but now want to change over to the new version. I was surprised to find out that I can only once assign a source column to a destination column. Why's that? In DTS, I could easily assi...more >>

I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2 installed). Recently, I have run sql server hotfixes deliveres over our organizational sus server. Although, it was run at least 6 times update could not be finished. Some errors were reported. Now I can not run DTS...more >>

I plan to create a windows form or web form to triger SSIS to do data inserting. I can see the current status in "SSIS"->" data flow", but how can I make them apper in webform or windows form? or anyway to access that information? The web form or winform may update every 3 seconds and somethi...more >>

I am building a DTS package that will transfer data from an Oracle server to a local MSSQL server. I have the data transformation task almost complete and working well, but the SQL query still needs to take a "batch" string parameter. I need to loop the transformation task each time for howev...more >>

I am trying to download product data from a supplier to put into an online store. The supplier gives me a list of warehouses, and i can only download from one at a time. I created a DTS script to download the warehouse specificed in DTSGlobalVariable("Warehouse"), but i can not figure out how...more >>

When another user try to work with my DTS he receives the following message: "only the owner of dts package 'MyDTS' or a member of the sysadmin role may drop it or any of its versions" How could I let him work with it without making him a Sysadmin? (For example- how could I change the owner of...more >>

I have a DTS package that connects to an Oracle Database and pulls some information from it with a SELECT query. I then take the results and place them in a table on the local SQL server. The DTS package has been wroknig fine for over a year, but there was an over sight on my part. I had no...more >>

Hi All, First of all is this the correct group for SSIS questions (I did not see an SSIS one)? Secondly my beginners question, I have Table A and B in my database, would like to process all records in Table A and do either an update or insert in Table B depending on wether or not the ...more >>

Hi, I'm currently setting up a SSIS package. The purpose is to read a comma-separated text file and call a webservice with the values from the text file using the webservice task in SSIS. The webservice methods are session-enabled that is, I call an Initialize-method, then the Add-method for ...more >>

I have a dts package that works fine when I execute it directly. However when I schedule a job to run it it fails on the 1st step. The first step ftp's a file from one network folder to another. If it is a rights issue what account do I need to give the rights to, and what rights should the ac...more >>

I have written a series of DTS packages which move data from a FOX database onto SQL2000. The packages work fine for small tables. However when I run a package that looks at a large table in FOX then I get an unspecified error in the DTS designer. Before the error comes up I get a message sayi...more >>

Hi. I have a simple DTS package that runs fine on a SQL 2000 server. But when I try to run it from within a SSIS parent package, it fails with: SSIS package "CopyFundWareTables.dtsx" starting. Error: 0x0 at Execute DTS 2000 Package Task: System.Runtime.InteropServices.COMException (0x80040...more >>

When retrieving a dynamic properties task in .NET the assignments collection is set to null. Is this a known bug, or is there something special that needs to be done to get the RCW to load this collection? Thx. ...more >>

Hi : For performance reasons, it has been identified that dropping an index before loading a table and then recreating it after loading, is beneficial. I would like to do this, but cannot get the syntax straight. If you have done it, please share your syntax 1. truncate tableA 2. drop ind...more >>

i have a package that picks up xls file from a specific directory, puts it into working directory. here is the problem. all files droped will have worksheets named diferently in order for me to read it i need to have the same name my excel read task is trying to read the sheet. i use a simple ...more >>

Hello, hope somebody can help me out! In 2005 I created some data views on SQL Server 2000 and used the DTS Export Wizard to set up 4 local packages which were scheduled as Jobs to run on a daily basis. These packages transformed SQL data into an MS Access database residing on the ser...more >>

Good Morning, SSIS in SQL Server 2005 I tried to assign a value stored in a variable to the flat file source connection using a script task as below and received the following error message. Dts.Connections("REJECTION_FILE").ConnectionString = Dts.Variables("gv_Extract_file").Value.ToStr...more >>

Hi All, Need to accomplish this in SSIS...if someone can point me the flow tips or how to proceed would sincerely appreciate it. The OwnerRecord_1 owns RecordA and RecordB....and so on...the owner record follows the record Flat File Input RecordA........... RecordB.................. OwnerRec...more >>

I have an SSIS pacakge that must be run using the 32-bit version of dtexec.exe. This is the command line that I use: "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /SQL \PnL\MarketingAllUploadXLSPIACCosts /Server dwhsql1 Our environment consists of a singe develo...more >>

Hello, I am currently deciding on what to do in a classic scenario: I am writing DTS packages that will be executing on the Development SQL Server and performing various tasks. Once I am satisfied with the DTS packages, I will migrate them to the Testing environment and then finally to th...more >>

I have a job that needs to copy a file from a network share to the local server. I'm using a FilesystemObject.Filecopy script and it works ok when executed under my admin account that has access to the network share. The problem I'm encountering is when I schedule the job. SQL (2K) is running...more >>

Within SQL Server 2000 , I am attempting to create a DTS Package to transfer data from Active Directory to SQL Server. Setting up the SQL Connector is no problem, but the list of OLE DB Providers does not include the provider for Active Directory. Checking the registry under HKEY_CURR...more >>

I'm importing a text file into a table using the DTS Transform Data Task. How can I get the number of the imported records? The global variable @@ROWCOUNT is equal to 0 in the next step (Execute SQL Task).. ...more >>

Hi In SQLServer 2000 is there any way to transfer ntext data. SO far every method we have tried has failed Is it possible thanks jc ...more >>

Is it possible to have a package (or any other automated functionality) that will UPDATE a table as opposed to INSERT. This is something that I have cared to do numerous times but for the life of me I can never get anywhere with it. ...more >>

I am concatenating data for the ticket process. I am now joining to another table (customer_own_Pnumber) for an additional column. The problem I’m having is data in that table does not always have their own part number in that table. So, when I join cust_ID or item_id (which does ...more >>

Hi all, I create a DTS package to import an csv file into 1 table on SQL Server. I don't have problem to execute the package directly. But I want to schedule this package to run on specific time during the day, therefore, I create a job and assign cmd command to run this package via this ...more >>

some users need to import the data once a while. instead of running from the server all the time, I am thinking to create an *.exe tool for them to run in their own machines. after create SSIS imorting tool, may I use it to create exe file or is it possible to create and winform *.exe applicatio...more >>

I am using the SQL Server 2000 Import and Export program to copy data from SQL Server tables to Oracle tables. I have the Import and Export program to create the Oracle tables. The table names in SQL Server are all lowercase how can I have the program create the table names in uppercase? ...more >>

If I get some script code to run at the end of a package execute, is there any way to tell the package is successful or failing at this point in script? I want to set a subject line for a mail task to SUCCESS or FAILURE....more >>

I see the OnPostExecute event. But how do I catch the one for the package? Can it be coded "generically" so I can copy it from package to package as needed?...more >>

Hi, I am using a 3rd party tool to generate OLAP cubes of our sql database. We have approximately 100 DTS packages to generate our cube data. There is a known bug in the interface that you cannot change the SQL server database account password used to run the DTS packages. In our company...more >>

Hi : 1. I import data into sqlserver, from an excel file, from a worksheet within it, named 'input_data' 2. then i scrub the data in sqlserver 3. then i export some data into the same excelfile but into another worksheet named 'output_data' I have got it working and this is how i am doing ...more >>

Hi Wanted to upload a text file to SQL table. one of the columns has data like below MDD - Inquiry abt showroom / dealers MPFW - Inq. about Product Features & Specification MRPC - Request For Product Catalogue / Broucher When transferring the data from the text file to SQL table, i wa...more >>

Hello, I try to prepare SSIS package with application written in C#, but I noticed problem with following code: CManagedComponentWrapper instance1 = source.Instantiate(); instance1.ProvideComponentProperties(); source.RuntimeConnectionCollection[0].ConnectionManagerID = pakiet.Connect...more >>

I would like to know how to automate the following two processes with excel: 1. I would like to take data that is obtained from sql server 2000 queries results and load the detail data onto excel spreadsheets. 2. I would also like to take data that is obtained from sql server 2000 query re...more >>

1) We need to give a hyperlink from our application to MS SQL Server Reporting Services, is this possible? Any idea? So from the client side browsers maybe via the internet or on a LAN on a click it should open the Reporting services. 2) We also need to give a hyperlink from our applicati...more >>

Hi, I got a Access database and I need to import a table to sql server. I am using the DTS feature to import the table. However, the import is failing with a message that column 43 ('shipdue', DBTYPE_DBTIMESTAMP) status 6: Data overflow Invalid character for cast specificatioin. In Access t...more >>

I have the following selection string in an SSIS package that selects a specific date from an Excel Connection source: SELECT FMonth, Plan, ACDCalls FROM [Data$] WHERE (FMonth =#5/1/2007#) I want to use a variable within the package that is in the format of 20070501. H...more >>

SQL-Server 2000. Independent (isolated) SQL-Server installations on laptop and on separate network. I've only been able to find ways to transfer a DTS package from one server to another on the same network. How do I transfer/copy a DTS package I have running on my (independent) laptop...more >>

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 >>