How to upload values from multiple CSV files to a single table using DTS.

s.nivedithaa@gmail.com

05-06-2008 07:03 AM
s.nivedithaa@gmail.com

Currently trying to get my head around this SSIS infrastructure which is a big shock after coming from DTS. I appreciate, as a developer, that...

Rob Nicholson

05-05-2008 03:19 AM
Charles Wang [MSFT]

Hi, we're kicking off a new predictive analytics online training program and allowing people to sign up at half price until May 21st. The online...

Elise Johnson

05-03-2008 07:24 AM
Elise Johnson

I'm trying to create a scheduled job on SQL Server Agent using SMO with VB.NET 2.0. Here's a short code snippet: Dim theServer As New...

Eigh

05-02-2008 04:09 PM
Eigh

Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have...

Andrew Stewart

05-02-2008 03:55 PM
robert@robertdennis.com

Hi, I'm using this query: SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' + 'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path...

surekari@gmail.com

05-02-2008 10:35 AM
Tomasz Borawski

Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that...

Broonie

05-02-2008 10:23 AM
Tomasz Borawski

How can I execute a SSIS package from a stored procedure? Thank you.

Jack

05-02-2008 10:18 AM
Tomasz Borawski

I have a DTS package that has the ActiveX Script code listed below that is used to call stored procedures in SQL Server database. The DTS package...

David P.

05-02-2008 10:13 AM
Tomasz Borawski

Hi, We can enable memory restriction (limit cache size) for “Lookup Transformation" in Data Flow Task, can someone tell me how exactly it effects...

Manan

05-02-2008 07:31 AM
jhofmeyr@googlemail.com

I have a DTS package that contains about 35 Execute SQL Task Properties. It there a sysobject/table object that I can use in listing all the...

Agho

05-01-2008 04:07 PM
Agho

Since a local system account doesn't allow backing up to another drive, I made a new domain account so we could backup to a different drive than...

Pat M - City of Reno

05-01-2008 08:43 AM
Russell Fields

Boy do I feel stupid. I have right-clicked and dropped down Tools and everything else and cannot seem to find if I can Re-Name a DTS Package. I got...

PSULionRP

04-30-2008 05:47 PM
PSULionRP

I have a DTS package that has the define code listed below. How do I find the values for each ? in the @SQLString listed below? Thank You, DECLARE...

Dean P.

04-30-2008 01:28 PM
Dean P.

Hello, is there a possibility to export several tables at once in csv - files? Regards Falko

Falko Schmidt

04-30-2008 08:26 AM
jhofmeyr@googlemail.com

Hi, we are using sql 2000, i would like to know is there a way to transfer multiple tables data (export and import) from one server to another server...

tulip

04-29-2008 12:12 PM
tulip

I have created a package that exports data to an excel file. The column headers (column A, column B, column C, etc) are currently in row 1 of...

doug

04-28-2008 05:19 PM
doug

Hi, I am trying to upload query data to a CSV file. I have created a DTS package and its running fine when i run it manually. But, when i schedule...

Sats

04-28-2008 11:04 AM
Sats

I'm getting "Invalid Authorization Specification" when i try to run a DTS package from excel. I get an error on this line.......I have been leaving...

Billy Rogers

04-25-2008 01:20 PM
Billy Rogers

I have installed the MS Samples but under the Tutorial Folder I only have the folder 'Creating a Simple ETL Package' which in turn only has...

Jack Maxwell

04-25-2008 12:05 PM
Jack Maxwell

I wonder if anyone could offer some guidelines on the following problem? I need to transfer records from a SQL Server table to an...

D.Stone@ed.ac.uk

04-25-2008 08:07 AM
D.Stone@ed.ac.uk

In the early stages of evaluation and what is needed software wise to migrate to SQL Server 2005. Currently, SQL Server 2000. I have some DTS...

mcauliffe

04-25-2008 07:39 AM
mcauliffe

I have a few queries I use to locate specific text within job steps, views and stored procedures. These come in handy if you need to do a "find...

c-eric.geil@mci.com

04-24-2008 04:40 PM
nite_eagle@hotmail.com

How can I export data between databases with different collation order (sql server 2000)??? I would like to export correctly characters such as...

Juan García

04-24-2008 09:14 AM
jhofmeyr@googlemail.com

Hello, can someone please tell me how to set up flat file connection object when the format of the file is as follows: Date Record(s) - Fixed...

Jason

04-23-2008 10:08 AM
Jason

Hello.... I am looking to limit what our developers can and cannot do in our SQL 2005 SSIS environment. We no longer have a dedicated DBA and need...

jeff

04-23-2008 09:45 AM
jeff

I have a created a dts package (SQL2000) and schedued it to run every 15 minutes - 24 hours a day, 7 days a week. There have been a couple of...

doug

04-22-2008 03:34 PM
doug

Hi gang, I am having a problem and could also use some help understanding something... We have a DB in MySQL (5.0.51) that I am transferring to SQL...

Christopher Burns

04-21-2008 05:11 PM
Kevin

I have had this problem before and I cannot seem to fix it now. There is a post with the same subject line to review. I think the solution I used is...

Jerry C

04-21-2008 04:51 PM
Kevin

All, Using the Business Intelligence Development Studio, I migrated a DTS package from SQL Server 2000. When I run the packaged from BIDS, it worked...

cappjr@gmail.com

04-21-2008 12:55 PM
cappjr@gmail.com

Hello there I've installed SSIS as part of SQL server 2005 on Server1. If i want to access from my computer to ssis it give me error: server...

Roy Goldhammer

04-21-2008 12:49 PM
Roy Goldhammer

Hello, I need to import zipped text files from an ftp site. Can someone please tell me how to go about doing this? I tried the ftp task, but was...

Jason

04-21-2008 01:58 AM
Charles Wang [MSFT]

getting this nice thing in my user acceptance test environment. The AcquireConnection method call to the connection manager "XYZ" failed with error...

Liliya Huff

04-21-2008 12:30 AM
Liliya Huff

Till to date large number of attacks are still carried out by guessing users password. A structured organization have well defined and imposed...

aden

04-19-2008 07:35 AM
aden

Now find maximum vulnerabilities in Windows, Oracle, Cisco and MSSQL with the help of Secure Auditor, a unified digital risk management solution....

aldous.alfred@gmail.com

04-19-2008 03:33 AM
aldous.alfred@gmail.com

I would like to run the SSIS package located on the 2005 sql server from my workstation on demand. The workstations do not have sql loaded. Is there...

Jack

04-18-2008 02:16 AM
Jack

Folks, We are now just embarking on our migration to 2005 from 2000. I have a server with 400 DTS pkgs. What happens to them after an in-place...

Scott H.

04-17-2008 10:37 PM
Scott H.

I am trying to take data from a table in one database and add it to an existing table in another database. The both use the same primary key. I set...

Sean Bolster

04-17-2008 05:35 PM
Sean Bolster

In my SSIS package, there is Execute DTS 2000 Task, the DTS packages called from Execute DTS 2000 Task have GLOBAL variables (Shown in Inner...

Vikranth

04-17-2008 03:51 AM
Vikranth

I'm looking for the actual files and not how to get to it in SQL 2000. I'm tyring to convert them to import them in SQL 2005 and it needs to know...

pvong

04-16-2008 11:58 AM
Bill_Orova

Hi gurus this is a problem that has just risen on a dts package My boss updated a dts package in sql server 2000 I created and he addded a custom...

Bill Orova

04-16-2008 11:14 AM
Bill Orova

I am having problems in transformation task. I am retrieving oracle data and loading into sql server table. Oracle retrieval works fine, at the time...

Ramu

04-16-2008 08:15 AM
jhofmeyr@googlemail.com

Hi all, I am kind of new in this topic and get stuck for awhile. I migrated DTS packages from SQL Server 2000 (Windows 2000) to be SSIS packages on...

Tanya

04-16-2008 02:42 AM
Tanya

I am using SQL Server 2000 DTS package. I am trying to re-define transformations between the source and destination tables while there are Temporary...

Justin Doh

04-15-2008 06:08 PM
Justin Doh

Hello, At my organization, a programmer who is no longer here created some DTS packages on our SQL Server 2000 installation. We need to update the...

Michael

04-14-2008 05:51 PM
Michael

Dear All i have table with 50 columns in which data is loaded from text files. now from recent up-gradation the one column has been added in the...

Jami

04-14-2008 05:14 AM
Jami

Can anyone refer me to official Microsoft documentation on how to dereference SSIS variables, and in what contexts they may be invoked? For example,...

Jay Way

04-11-2008 02:24 PM
Jay Way

Hello, I've been battling this issue since morning. Some Internet forums point out that it's some sort of a MS bug, but I couldn't find a definative...

sergei.sheinin@ru.nestle.com

04-11-2008 04:07 AM
sergei.sheinin@ru.nestle.com

Hi. I am using SQL 2000 and DTS package to transfer data between two databases. In my DTS package, I need to create a enumeration task with...

Drum

04-10-2008 09:16 PM
Drum

Hello, I have a SQL 2000 dts package with a transform data task that copies around 15million rows of data from a unix server. The db where the rows...

Mark

04-10-2008 08:09 PM
Mark