Hello, I have been able to create SSIS packages for my Access 2003 table migration to SQL 2005. After attempting to import the tables with Foreign...

James Scho

12-07-2009 11:29 PM
James Scho

I need to import huge data from text file (3G) with fixed length into a existing SQL table. Can someone give me a hint? -- Message posted via...

aspfun via SQLMonster.com

12-07-2009 11:05 AM
aspfun via SQLMonster.com

I have a simple SSIS package that uses an Excel spreadsheet as the source and attempts to load mulitple rows into a SQLServer 2008 database table. ...

Whiskey Romeo Lima

12-04-2009 06:51 PM
Whiskey Romeo Lima

Can anyone point me to an example of how to debug packages deployed to SQL Server. I use "Execute Package Task" and the package is located SQL...

t.maeda

12-04-2009 02:45 AM
Charles Wang [MSFT]

Hello, I have installed Microsoft OLE DB Provider for DB2. I have a problem with string parameters when updating records on AS400/DB2 when using OLE...

Tomas Novotny

12-03-2009 09:21 AM
alan levy

I want to import text data into SQL using "import and export wizard". There is no text option under the list of data source. How to add...

aspfun via SQLMonster.com

12-03-2009 07:56 AM
Todd C

Hi I have a DTS package that I can't change that I have exported to a new server runnig SQL 2005. I have installed the package...

Brian

12-03-2009 07:52 AM
Todd C

Hello I need to get a package name in the Custom Log Provider overrided of LogProviderBase class. But the parameter of Log() method does not have...

t.maeda

12-03-2009 07:47 AM
Todd C

I have several SQL Server 2005 SSIS packages. What tables or t-sql query can I run against the MSDB database to obtain detail information about...

Joe K.

12-03-2009 07:45 AM
Todd C

We have 2 SQLServers 2005 std, both on windows 2003 servers 64 bit. On one server the DTS works fine but on another the following error appears; SQL...

nigel

11-30-2009 03:13 PM
Russell Fields

Hi I have a big problem with an SSIS package. First of all it’s running on a windows server 2003, SQL server 2005 and Office 2003. The package...

taariq

11-30-2009 08:56 AM
Todd C

I am trying to import a fix length text file in database table using DTS under SQL Enterprise Manger v8.0. The text file has 360 fields and a total...

BrendanDowns

11-24-2009 06:01 PM
BrendanDowns

Hey, I have an import from a flat file that has 70 plus rows. One row's counterpart is an int. One row failed, it contained a space, where...

Bill W

11-19-2009 11:42 AM
Bill W

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 08:21 AM
Mia

More than anything, it’s a generic interface to your data. Any data. If it can be shown in a tabular format, we can work with it. (six months of...

Mia

11-17-2009 10:07 AM
Mia

Hi all, I'm a SSIS newbie and I'm attempting to set up a simple Script task.In the Edit Script Task, I have the VB code shown below. However, I...

Ryan Gomez

11-17-2009 08:48 AM
Todd C

So it automatically updated my package. How do I code on my box with SQL2008 a SSIS to run on SQL2005? I've tried reinstalling the SQL2005 tools to...

richard.hunt

11-17-2009 12:50 AM
Todd C

is SSIS available SQL Server 2005 Standard Edition? -- Ilya

Ilya

11-12-2009 11:11 AM
Todd C

Hi all, I have a global variable G1 of string type, and i would to set it as datetime Iso 8601 compliant ( yyyy-MM-ddT00:00:00 ). When i try to...

Niki AU

11-12-2009 06:22 AM
Niki AU

Hi all, I am executing a DTS package from a C# application that runs on the IIS. The database used, is on different machine. My question is, will i...

Sharon

11-11-2009 06:44 AM
Sharon

Is there a query/view/system table to count the nummer of SSIS packages on a SQL Server. Joost

Joost

11-11-2009 06:21 AM
Alessandro Alpi

Hi, One of our developers, connecting to SQL through standard security, had copied and modifed a DTS package but is unable to execute it. The...

Rob

11-10-2009 10:48 AM
tbradshaw via SQLMonster.com

Hi I have been asked to install sql server 2000 dts designer components on a 64bit SQL 2005 server. The 2005 server is a production server and I am...

Steve

11-06-2009 06:36 PM
Paul Shapiro

Hello, I am trying to run an SSIS job that has to access some EFS protected directories. If I run the package directly as the user that owns the...

jdm_222

11-03-2009 04:54 PM
Todd C

I am attempting to send files from Windows to linux ftp. I am getting this error message which I am not able to understand. I have tried all the...

Vishwanathan Raman

11-03-2009 09:27 AM
Todd C

I have a SSIS package with Script Task created in SQL Server BIDS 2008 . When I open the Script Task Editor and click on the 'Edit Script' button. I...

Roberto

10-30-2009 08:33 AM
JohnBarryAtUconn

Recently upgraded from 2000 to 2005. Running DTS jobs until we have time to convert to DTS packages to SSIS. Several times we have gotten a...

JohnBarryAtUconn

10-27-2009 10:39 AM
JohnBarryAtUconn

Recently upgraded from 2000 to 2005. Running DTS jobs until we have time to convert to DTS packages to SSIS. Several times we have gotten a...

JohnBarryAtUconn

10-27-2009 10:33 AM
JohnBarryAtUconn

I am trying to setup a scheduled data transfer b/w SQL Server 2005 and IBM DB2 UDB v9.5 (Unix/Sun Solaris). I am using the latest IBM ODBC drivers...

MZeeshan

10-26-2009 03:05 PM
MZeeshan

why it appears in DTS packages...I need all probable reasons EggHeadCafe - Software Developer Portal of Choice ASP.NET DropDown ListBox and XML...

sonal keliya

10-26-2009 01:24 AM
sonal keliya

I have an old cold fusion custom tag (I wrote some years ago and have lost the C++ code behind it). The running of the cold fusion script is...

James

10-21-2009 06:24 PM
James

We're trying to build an SSIS package that will take a list of servers, connect to each & run code. However, if a server is down for whatever...

M Bourgon

10-20-2009 09:21 AM
Todd C

Hi, Very new to SSIS. I have set up a simple package that ends with sending me an email just to test the email functionality. I've setup a send mail...

fig000

10-19-2009 12:01 PM
Todd C

Hello, I have SQL Server 2008 64bit version on the server. Integration, Reporting, Analysis services are installed there too. I want to connect...

Mirek Endys

10-14-2009 05:50 AM
Charles Wang [MSFT]

Hello, I'm trying to get dtutil to sign a package. It reports no error, but I see no difference in the package when I open it in a text editor....

Todd Beaulieu

10-09-2009 02:56 PM
Todd Beaulieu

Hi all, By using the "/W True" switch to DTSRun, I can get the completion status of each DTS package run into the event viewer (as per the manual)....

HWV258

10-08-2009 01:34 AM
HWV258

Dear all I have a datawarehouse on SQL Server 2005. On of the source systems runs Navision with a SQL Server 2005, that gets upgraded to SQL Server...

Marc

10-07-2009 02:56 AM
Marc

Do you have Excel installed on the server? -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified...

Dave Patrick

10-05-2009 01:51 PM
Dave Patrick

Hi I need to create a SP with the following fake code: (Sql Server 2005) .... If DB1 is available and DB2 is available Insert into DB3 Select field1,...

Don Juan

10-05-2009 07:46 AM
Don Juan

From what I've come to understand, a user logs into the SSRS site and his/her Windows Identity is passed into the SSRS server. We, on the SSIS...

sam01m

10-04-2009 11:21 PM
Charles Wang [MSFT]

I'm having trouble loading a DTS Package from a file. The error says the file does not exist, but I'm looking at it in the file system. I...

TDuck

10-02-2009 03:01 PM
TDuck

Hi everyone, I wanted to make sure you know about the next Predictive Analytics World conference, Oct. 20-21 in Washington DC...

EliseJ

10-01-2009 02:02 AM
EliseJ

Hi, My SSIS solution includes a custom .Net assembly that I reference from script components within my packages. I deploy multiple instances of...

Scott Munro

09-29-2009 04:40 AM
Scott Munro

Hi, I need to export data from sql table in txt file in same folder with name of the file which is constant in first part ( like 'test.'), and after...

Spider Jerusalem

09-24-2009 10:06 AM
Spider Jerusalem

The OraOLEDB issue on BIDS & SQL Agent under 64bit Windows system is kind of famous issue.. Recently I found the solution that works for me. That is...

Jeyong Park

09-23-2009 05:22 PM
Jeyong Park

I am passing 3 million rows into a Fuzzy Grouping tranform, grouping on 3 columns. I have a dedicated server with 8Gb of RAM. 4Gb is in use, cpu...

Chris

09-23-2009 11:18 AM
Chris

I have exactly the same problem. Any solutions so far? From...

Dan

09-22-2009 01:08 PM
Russell Fields

Hi Guys, I have few questions that hopefully will give me the correct way forward with these issues. As part of a project I receive 3 CSV files,...

Lez

09-16-2009 08:37 AM
Todd C

Fellow SSISers: I have a fully working DTS package that runs an Execute Process task. The Execute Process task bcp's the output of a stored...

JJ of Eugene OR

09-15-2009 11:13 AM
sugavaneswaran

To help troubleshooting, I'd create a simple test table on A and try to do an INSERT into that test table from B using the linked server just to see...

Linchi Shea

09-12-2009 10:11 AM
Linchi Shea