Dear All, I have created a DTS (SQL 2k SP4) and its worklow is as follows: Step1 --on completion--> Step2 -- On completion --> Step3 ... when it...

jouj

11-20-2007 08:49 AM
jouj

SSIS newbie here. I set up my foreach loop, put a file task in there, and was able to copy all the files in a folder. Swell. I had a separate data...

JRStern

11-19-2007 11:22 PM
JXStern

We are looking for a pointer to a best practices document for migrating DTS packages from SQL 2000 to SQL 2005 x64. Our specific problem is that we...

Marc Harrison

11-19-2007 02:26 PM
Allan Mitchell

Hi, We use SQL Enterprise Manager in the workplace. I have several jobs scheduled via the Management section of Enterprise Manager. They run...

Jim Moberg

11-19-2007 02:23 PM
Allan Mitchell

SQL2005 SP2 Is there a way to add a variable to a backup name with SSIS. Our backups are located on a central server and I need to add the prefix...

brymer28303

11-19-2007 02:22 PM
Allan Mitchell

While on a server, I created a simple package to copy data from one table to another. When a user logs into EM from a workstation and attempts to...

Roger

11-19-2007 02:14 PM
Roger

Hi, I have to import Excel file to SQL Server 2005 using SSIS. I am having alot of problems and was wondering if it's no trouble if you could please...

avital@business-solutions.co.il

11-19-2007 06:08 AM
jhofmeyr@googlemail.com

Hello, I have this problem I can't add the Microsoft.Office.Interop.Excel in a Script Task to execute a Macro in a Excel Sheet and in a ActiveX...

Armand

11-19-2007 05:59 AM
jhofmeyr@googlemail.com

OK, I posted my question late on Friday and don't really expect an answer soon (if at all), but looking back at the dates here, just a few new...

JRStern

11-19-2007 05:57 AM
jhofmeyr@googlemail.com

I have intermittent failures with DTS packages since 8/9. The error messages I am recieving are cryptic at best. Can anyone help with...

mikejwh@gmail.com

11-15-2007 12:05 PM
Jay via SQLMonster.com

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

=?Utf-8?B?RWFnbGVCZWVr?=

11-14-2007 06:13 PM
Chris

Hi I am trying to use Transfer SQL Server Object task to transfer various DB objects from a Source DB to a newly created Destination DB....

whirlwnd

11-14-2007 02:02 PM
Hilary Cotter

I have SQL Server 2000 DTS package There are four task 1. creating a temp table by joing different table on same server server 1. 2. Truncate...

Kalyan

11-14-2007 12:02 PM
Test Test

Hi, I have multiple DTS packages w/ multiple connections to Teradata DW with a transformation tasks from Teradata to SQL Server. From time to time,...

wer61537@yahoo.com

11-13-2007 07:28 PM
wer61537@yahoo.com

Good Morning! i am a newbie at DTS and SSIS, and I am a little confused. I have imported data from another database, and created and saved an...

Krzysztof via SQLMonster.com

11-13-2007 09:16 AM
Krzysztof via SQLMonster.com

Hello, Does anyone know how to rename an SSIS project? Is it even possible? Thanks, Bill

billsdropbox@gmail.com

11-13-2007 07:51 AM
Todd C

I'm currently backing up to a network location but I'd like another opinion. My objective is to move the backups to a remote location. I am...

vncntj@hotmail.com

11-12-2007 10:42 PM
vncntj@hotmail.com

I'm getting this wierd error message when I try to run SSIS package as SQL Agent job? Any ideas? Date 11/11/2007 10:00:00 PM Log Job History...

dba

11-12-2007 12:12 PM
Mike C#

I have a dts package that imports data from an Excel sheet directly into a table. One of the columns which has data in the Excel file yields all...

Henry Berry

11-12-2007 04:10 AM
jhofmeyr@googlemail.com

Hi, I am currently trying to copy over 3000 logins from a SQL 7 machine to a SQL 2000, via DTS and Transfer logings task. Currently the process has...

quackhandle1975@yahoo.co.uk

11-09-2007 06:28 AM
quackhandle1975@yahoo.co.uk

Hello all, I have not yet run into this, but I imagine that I will at some point. So I thought I would ask and find out so I know when the time...

Conan Kelly

11-08-2007 10:33 AM
jhofmeyr@googlemail.com

hey friends, I am trying to pass parameter to transform data task in sql server 2000 and on putting ? as parameter place holder and clicking...

Jwalant Natvarlal Soneji

11-08-2007 10:03 AM
jhofmeyr@googlemail.com

Hello all, I was trying to set up an SSIS Package (intended to be run manually) to prompt for a folder, and then loop through all files in that...

Conan Kelly

11-08-2007 06:04 AM
jhofmeyr@googlemail.com

Hi everyone! I just imported a flat file of 300+ fields from a non-sql application (horrible high-profile application) successfully using SSIS!!!! ...

thomasjbs@yahoo.com

11-08-2007 04:38 AM
jhofmeyr@googlemail.com

Hi, Trying to dynamically set the connectionstring property of the excel source. This is what I enter instead of the hardcoded excel file...

arkiboys2

11-07-2007 05:58 PM
Conan Kelly

Hi, I have to import data from a flat file. There are some empty values in the flat file. When I import it using SQL 2000 Import Wizard, null values...

Mike Caceres

11-07-2007 03:15 PM
Mike Caceres

I am using the wizard to import a comman delimited text file into a new database. I make all of my choices during the wizard and the preview...

Marty Shifflett

11-07-2007 12:05 PM
Marty Shifflett

My ssis package exports .xls file data into a sql server table. The fields in the sql server table have to be nvarchar instead of varchar. If I use...

arkiboys2

11-07-2007 09:20 AM
jhofmeyr@googlemail.com

Hi, I am trying to create a job to run a ssis package. The job fails. Looking at the history log, there is no proper information on why the job...

arkiboys2

11-07-2007 09:14 AM
jhofmeyr@googlemail.com

I am trying to migrate my Sql2000 DTS to SQL2005 packages using the Migration wizard. When I try to migrate using Windows Authentication I get the...

bozzzza@lycos.co.uk

11-07-2007 06:20 AM
bozzzza@lycos.co.uk

I would like to know how to transfer a global variable value to Visual FoxPro Free Table? In DTS, I created a Execute SQL Task with data source...

May

11-07-2007 01:44 AM
May

Hi, I am joining between Teradata and SQL server and I trying to figure out how to create a DO WHILE loop that will populate a table with multiple...

DK

11-06-2007 07:08 PM
DK

While executing DTS packages in SQL 2005 64-bit Enterprise Edition (we haven't moved to SSIS yet), I am seeing the following message in the...

Smarty

11-06-2007 04:29 PM
Smarty

Hi, Using sql server 2005 ssis package. I am looping through excel files to import data into a sql server table. Added a filename variable. This...

arkiboys2

11-06-2007 08:14 AM
jhofmeyr@googlemail.com

I need some clarification on how the dts handles the following situation: I have a dts package with max concurrent steps set to 1. I have an active-x...

Viji.Chidu@gmail.com

11-06-2007 04:00 AM
jhofmeyr@googlemail.com

Hi, Using SSIS, I am successfully importing data from excel files into a table in sql server 2005. These excel files are ALWAYS open and are being...

arkiboys2

11-06-2007 03:25 AM
arkiboys2

I am trying to import XML data trough external XML schema file. The schema is valid and I was able to create relational database based on it. When...

zk_

11-05-2007 01:53 AM
Peter Yang[MSFT]

I have a database named MCP and a SQL Login MCP_USER (not sysadmin). MCP_USER has db_datareader, db_datawriter and db_ddladmin permissions on...

Julio Mattos

11-04-2007 11:05 PM
Julio Mattos

Hi, I've got a package that runs ok on 32bit SQL 2005 SP2 on a single node, but when I move it to SQL 2005 x64 cluster I get the...

RichardT

11-04-2007 08:41 PM
RichardT

Hi, I have an excel spreadsheet with several sheets. These sheets get populated with data from an external source database i.e. a third party...

arkiboys2

11-02-2007 08:13 PM
jhofmeyr@googlemail.com

When I open Business Intelligence Development Studio and go to new Project, the DTS template is missing. I'm pretty sure I installed everything when...

andy

11-02-2007 06:38 PM
Francisco A. Gonzalez

Ther eis an excel file. This file is open all the time so the excel sheets get populated by an external third party application real time. So the...

arkiboys2

11-02-2007 11:01 AM
Francisco A. Gonzalez

I am trying to import an Excel file - when I pick the file I get the message "Could not open file for reading. Close any other application that may...

SJ

11-02-2007 10:01 AM
SJ

I am new to DTS. I would like to know how to transform a global variable value to Visual FoxPro Fee Table? I created a Execute SQL Task with...

May

11-02-2007 02:51 AM
May

How can I import a Flat File, adding an incrementing Row Number? I tried VB in Access 2002/SQL 2000 and Access 2007/SQL 2005, using Line Input #1,...

Aubrey

11-01-2007 09:32 PM
Peter Yang[MSFT]

I recieved this error 'SELECT permission denied on object 'FEIProviderAddresses', database eRW owner 'dbo'' on a failed DTS package. Can someone...

Jay via SQLMonster.com

11-01-2007 02:37 PM
jhofmeyr@googlemail.com

Hi, I've been using SQL2000 along with QA and EM for a number of years now and have grown accustomed to it's ways. My company is in the process of...

11-01-2007 02:14 AM

Guys, I am trying to create a package where an Excel file is imported to a SQL Server 2000 Database. Some columns contain text that is larger than...

Marios

10-31-2007 09:41 PM
jhofmeyr@googlemail.com

I am working on a project that has hundreds of DTS packages in use. The company plans to convert the database engine to SQL Server 2005 next month....

crowelldj@gmail.com

10-31-2007 02:07 PM
crowelldj@gmail.com

My SQL database was created using the Access utility to convert an Access database to SQL. On the SQL Server, I have a DTS package that exports the...

asleepatdesk

10-31-2007 12:09 PM
asleepatdesk