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 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 11:50 AM
Joe Go to last post
8 49
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 08:57 PM
qjlee Go to last post
16 197
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 03:23 PM
Mike Go to last post
0 149
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 01:26 PM
Joseph Go to last post
0 45
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 01:24 PM
Joseph Go to last post
0 145
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 08:53 AM
LearningVisualC2005 Go to last post
0 74
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 09:17 AM
Todd C Go to last post
8 50
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 09:28 AM
CJ Go to last post
16 81
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 09:28 AM
pxb Go to last post
0 153
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 05:58 PM
JL Go to last post
0 44
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 02:22 PM
Rockitman Go to last post
16 59
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 04:46 AM
Davide Go to last post
32 357
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 03:18 AM
msnews.microsoft.com Go to last post
16 49
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 03:02 AM
Mark Han[MSFT] Go to last post
64 193
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 11:18 PM
pxb Go to last post
0 47
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 09:20 AM
Mr Not So Know It All Go to last post
0 36
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 03:27 PM
nitin.narang01@gmail.com Go to last post
0 49
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 10:19 AM
Moby Go to last post
0 66
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 09:01 AM
Todd C Go to last post
24 253
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 07:56 AM
Todd C Go to last post
8 32
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 04:10 PM
Peter Go to last post
8 38
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 04:03 PM
Craig Stewart Go to last post
8 66
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 03:02 PM
Anonymous Go to last post
0 46
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 08:58 AM
MIB Go to last post
0 54
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 08:43 AM
richard.hunt Go to last post
16 94
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 11:52 PM
Augustin Prasanna Go to last post
0 43
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 12:45 PM
Matthew Wieder Go to last post
0 49
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 09:27 AM
Todd C Go to last post
8 44
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 03:22 PM
Russell Fields Go to last post
8 44
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 10:55 AM
sandeep chandrashekar Go to last post
0 54
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 10:11 AM
Rokal Go to last post
0 45
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 11:08 AM
Bird Byte Go to last post
16 265
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 08:53 AM
Todd C Go to last post
8 151
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 08:49 AM
Paul Shapiro Go to last post
40 303
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 08:46 AM
Todd C Go to last post
8 54
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 04:30 AM
msnews.microsoft.com Go to last post
16 156
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 10:52 PM
Mark Han[MSFT] Go to last post
32 323
Hello, Someone sent me a cube file. I restored it and the cubes work great. Can someone please tell me how I can save the online cube to a project...
Jason
10-19-2008 02:55 PM
Jason Go to last post
16 184
Hi SQL server experts, I tried to import a text file which has a row that has a column of value 222945700 This value is imported into an INT column...
Pingx
10-17-2008 05:21 PM
Pingx Go to last post
0 59
Hello Gurus, Enviroment: SQL Server 2000 SP4 Build 2187 Windows 2003 SP2 Receiving the following error Microsoft Excel Open method of Workbooks...
FredG
10-16-2008 10:19 AM
FredG Go to last post
16 96
I am working on migrating a database for SQL 2000 on a Windows 2000 server, over to SQL 2005 on a Windows 2003 server A large amount of the data in...
Irvine, Dennis
10-15-2008 10:39 PM
den Go to last post
40 319
Currently I have two SQL servers that need SSIS packages run against them to upload data from excel or access. The preferred method is to have an end...
Dwight
10-15-2008 07:14 PM
Irvine, Dennis Go to last post
8 44
I am trying to recreate some fairly simple data exports that I had in 2000 DTS packages. I created them by using the data export wizard and...
Nathaniel
10-15-2008 01:33 PM
matteus Go to last post
16 64
Hi All, I would like to convert RecordSet to comma separated values in my SSIS 2005 package. I populate a recordset usinq a SQL task: (select...
Pasha
10-14-2008 03:21 PM
Pasha Go to last post
24 181
We have a data feed from our SQL Server 2005 Datawarehouse that is feeding data to Oracle 10g. This feed had been working great for several weeks...
jwall76
10-14-2008 08:41 AM
jwall76 Go to last post
0 45
We have a data feed from our SQL Server 2005 Datawarehouse that is feeding data to Oracle 10g. This feed had been working great for several weeks...
jwall76
10-13-2008 01:12 PM
jwall76 Go to last post
0 130
Newby here: Where do you do VB Transformations in SSIS? Like...
robboll
10-10-2008 12:24 PM
Todd C Go to last post
8 31
I am running an SSIS job from a VB.NET application by calling sp_start_job. The return value I get is only whether or not it was able to start the...
Steve Jensen
10-08-2008 02:16 PM
Sony A Go to last post
13 150
Hello, I am trying to build a solution that extracts data from some large SQL Server 2005 tables to MS Access databases on a regular scheduled...
hfdev
10-08-2008 11:02 AM
hfdev Go to last post
56 157
I have a UTF-8 encoded comma delimited file. If I try to load that into a table using an OLE DB Destination. It goes in as Code page 1252...
Brad Deem
10-07-2008 06:50 PM
Brad Deem Go to last post
0 88
Post New Thread

Display Options
Showing threads 451 to 500 of 12840
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 - 2012, Jelsoft Enterprises Ltd.