dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss in the microsoft.public.sqlserver.dts forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.dts Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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 Go to last post
0 58
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 Go to last post
0 151
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 Go to last post
0 75
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 Go to last post
0 93
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 Go to last post
16 91
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 Go to last post
0 186
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 Go to last post
0 82
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 Go to last post
24 225
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] Go to last post
24 132
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 Go to last post
8 78
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 Go to last post
0 86
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 Go to last post
0 65
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 Go to last post
56 415
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 Go to last post
8 73
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 Go to last post
16 252
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 Go to last post
0 175
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 Go to last post
0 63
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 Go to last post
0 164
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 Go to last post
0 99
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 Go to last post
8 71
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 Go to last post
16 116
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 Go to last post
0 185
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 Go to last post
0 70
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 Go to last post
16 82
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 Go to last post
32 413
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 Go to last post
16 76
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] Go to last post
64 251
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 Go to last post
0 65
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 Go to last post
0 57
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 Go to last post
0 68
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 Go to last post
0 88
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 Go to last post
24 286
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 Go to last post
8 46
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 Go to last post
8 54
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 Go to last post
8 91
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 Go to last post
0 64
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 Go to last post
0 71
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 Go to last post
16 121
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 Go to last post
0 65
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 Go to last post
0 71
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 Go to last post
8 67
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 Go to last post
8 67
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 Go to last post
0 75
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 Go to last post
0 84
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 Go to last post
16 289
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 Go to last post
8 178
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 Go to last post
40 349
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 Go to last post
8 75
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 Go to last post
16 182
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] Go to last post
32 359
Post New Thread

Display Options
Showing threads 451 to 500 of 12853
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.