I would like to write a DMO/vbscript/activex control in DTS to access other DTS packages' connection objects properties. It it possible and if so...

Snake

11-21-2008 03:39 PM
Snake

Hi, I have a problem when a DTS is called by a scheduled JOB The DTS is copying Data from an Accpac dataBase by using a ODBC Data source...

GC

11-21-2008 01:08 PM
GC

I need to convert a SSIS custom component from SQL Server 2008 to 2005. In particular, I need to solve an error...

Pasquale

11-21-2008 07:35 AM
Pasquale

Hi I have the following in a dts package which picks a certain xml file and reads it into the database. It does this successfully when the path...

jojo123

11-21-2008 04:26 AM
jojo123

Hi, Can we use one xml config file for multiple packages? If yes, how can we store the different connection strings (like I have different...

xyz_jat

11-20-2008 08:09 AM
Todd C

Hi, I am trying performing a migration some data of an Oracle database to another Oracle database using the DTS, but when something occurs wrong my...

Jean

11-19-2008 10:59 AM
Jean

As far as I can tell there is no way to do a fastload or bulk insert if you need to use the EncryptByKey function on a field that is being...

MDC

11-19-2008 09:14 AM
MDC

Are there DTS improvements in Windows Server 2008 that would justify upgrading from Windows 2003 to Windows 2008? The SQL Server instance...

ggreeson

11-18-2008 08:34 AM
Russell Fields

I'm using SQL Server 2005, and need to automate running a stored procedure once a day. Used to use DTS package to do that, but that is not in...

Gerhard

11-18-2008 12:29 AM
Mark Han[MSFT]

Hi all I have a trouble with my dtsx package, these are the scenarios: - When designing my webpage I call a package by code or by command...

Don Juan

11-18-2008 12:15 AM
Sylvain Lafontaine

Hi, I created a datapump task in SQL SERVER 2000 DTS. The source for the task is stored procedure and destination is a tab delimited text file....

SRIRED

11-17-2008 03:05 AM
SRIRED

Hello, I have a DTS package containing several SQL Tasks. I would like to get all the SQL commands in a single file to edit them in an easy...

Joachim Hofmann

11-16-2008 05:58 AM
Joachim Hofmann

If I right click the local package I created in Enterprise Manager( a simple FTP download), there are options to Execute the package as well as...

Rockitman

11-14-2008 12:30 PM
Russell Fields

I have been following Darren Green's excellent article on executing DTS packages from SPs... I am stuck now though, I have everything working great,...

Joe

11-14-2008 10:50 AM
Joe

I have a table called MemberRnrollment, which contains two columns, EnrollmentDate and Enrollee. I need to create an SSIS to send me the total...

qjlee

11-13-2008 07:57 PM
qjlee

A DTS package that inputs a flat file. The file's name is set using dynamic properties task. I need a task to detect if the file is empty and...

Mike

11-13-2008 02:23 PM
Mike

Can I read each individual row in a flat file using integrated services, each row is fixed position and some rows contain a different amount of...

Joseph

11-12-2008 12:26 PM
Joseph

Can I read each individual row in a flat file using integrated services, each row is fixed position and some rows contain a different amount of...

Joseph

11-12-2008 12:24 PM
Joseph

I have some DBFs that i created from foxpro. How can I DTS them into a sql table? Ive never done dts before so a walk through would be nice. ...

LearningVisualC2005

11-12-2008 07:53 AM
LearningVisualC2005

Hi i am getting the next error : SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is...

eyalso@gmail.com

11-11-2008 08:17 AM
Todd C

Hi, I have very poorly designed DW and OLAP environment and am having problem with different behavior of default sorting order on database View in...

CJ

11-07-2008 08:28 AM
CJ

When designing an SSIS package data flow, I can see an XML Source but no XML destination, am I missing something or if this is a limitation of SSIS...

pxb

11-07-2008 08:28 AM
pxb

Could anyone please assist? I need to have Autofilter on a Protected Excel worksheet, but I can't seem to get it working. I know the same thing can...

JL

11-05-2008 04:58 PM
JL

I created a simple package that just doesn't want to run regularly. It's simply an FTP download and overwriting a single file in a directory. I...

Rockitman

11-05-2008 01:22 PM
Rockitman

Has anyone been able to get the DTS designer to work in the 2008 management studio? I had it working in 2005 SSMS, now it will not work in either...

Bruce

11-03-2008 03:46 AM
Davide

Hi, I am a DBA. We deploy SSIS packages on MSDB when a migration request comes from the developers. The config file is on a file system. The...

Uma

11-03-2008 02:18 AM
msnews.microsoft.com

I upgraded our SQL Server 2005 sp2 installation to SQL Server 2008. The installation is a 32 bit install on a 64 bit Windows Server 2003 R2. ...

TomM

11-03-2008 02:02 AM
Mark Han[MSFT]

In a Dataflow task, aside from the built-in Excel Destination, is there any other options for Excel support that provides richer functionality? Such...

pxb

11-02-2008 10:18 PM
pxb

I'm new to SSIS. When i used SQL 2000 and DTS, I was able to call a DTS package from a stored procedrue. Can I do the same with DTSX or SSIS...

Mr Not So Know It All

11-02-2008 08:20 AM
Mr Not So Know It All

I have DTS package which is scheduled to run every day and imports the data from Web server log files into Database which is on another server. This...

nitin.narang01@gmail.com

10-31-2008 02:27 PM
nitin.narang01@gmail.com

how can i accomplish that i can work with multi user on one ssis/bi projekt? specificaly regarding dimensions and cubes. is visual source safe the...

Moby

10-31-2008 09:19 AM
Moby

Hello Everybody, I do have question abt archive and deleting file from remote server using SSIS. I have one database server (payrollproduction) where...

mvp

10-31-2008 08:01 AM
Todd C

Hello, Iam trying to pass parameters to Oracle via SSIS data flow task but Iam getting "Invalid SQL command" Oracle error. This is what I have...

msnews.microsoft.com

10-31-2008 06:56 AM
Todd C

I have an SSIS package which uses an OLE DB connection to a SQL Server 2005 database. It then runs a script component to manipulate the data...

Peter

10-29-2008 03:10 PM
Peter

I am trying to export data to an Excel file from from SQL Server Integration Services (2005). The details of the error I'm encountering are...

Craig Stewart

10-29-2008 03:03 PM
Craig Stewart

SQL 2000 I can not open any of our DTS packages. If I go to design package, I get the following error: Error Desc: DBNETLIB ConnectionRead recv...

Anonymous

10-29-2008 02:02 PM
Anonymous

Hi, I have a control flow, at the end i'm trying to send a very big file (a zip). Because we have some network problem, i would like to try it until...

MIB

10-29-2008 07:58 AM
MIB

Ok, So here is what I have. I have 2 different sql queries that need to go into the same flat file. What I've done is created a dynamic variable...

richard.hunt

10-29-2008 07:43 AM
richard.hunt

When we try to import data from an excel, we are getting an error 'data for source column <column name> is too large for the specified buffer...

Augustin Prasanna

10-28-2008 10:52 PM
Augustin Prasanna

using an ODBC dbf connection in the import/export wizard, I am finding that I am unable to use traditional SQL syntax in the "Provide a Source...

Matthew Wieder

10-27-2008 11:45 AM
Matthew Wieder

How would I go about creating an exact replica of a dBase file as a SQL table? Using SSIS, I can create the data source from the dBase file, but...

Matthew Wieder

10-25-2008 08:27 AM
Todd C

I have created a DTS package on my TEST server in SQL 2K. I want to move this package to PROD. I cannot script and hand over it to my DBA. What is...

Giri Palakodeti

10-23-2008 02:22 PM
Russell Fields

I have created a dts package where in which I am pulling a data from sql server to excel. before doing this I have used a activex script to run a...

sandeep chandrashekar

10-23-2008 09:55 AM
sandeep chandrashekar

I want to create a DTS Package to pull data from an Oracle table into a SQL2K table. How can I insert rows that are not already in the SQL2K table...

Rokal

10-22-2008 09:11 AM
Rokal

I have a DTS package with an Excel spreadsheet as the source and a text file as the destination. There is a transformation that occurs on the data...

Bird Byte

10-21-2008 10:08 AM
Bird Byte

In my package, i'm using an DSN connection with a password to DB2. When the package is running on my PC, every thing is working very well. But when...

MIB

10-21-2008 07:53 AM
Todd C

I have a .dtsx that I originally created in VS2005. I would like to get the designer of VS2008 to be able to edit the code so that I can maintain...

michael

10-21-2008 07:49 AM
Paul Shapiro

Hi, I have an SSIS Package which I build and deploy to a Database Server where I schedule it to run daily. When it runs it uses the Connection...

C

10-21-2008 07:46 AM
Todd C

Hello, Iam trying to execute the below query against Oracle OLEDB Source in a data flow task: select frq_code, frq_name, update_frq, ...

msnews.microsoft.com

10-21-2008 03:30 AM
msnews.microsoft.com

I'm using bcp command to export a sql server table to an excel sheet. I've created a bcp format file to use with the command. It looks like this...

pensio

10-19-2008 09:52 PM
Mark Han[MSFT]