I have a DTS Package that I call from a Stored Proecure. The stored proecdure passes a department code parameter (3 character text string) to the DTS Package. The DTS Package doesn't seem to s...
Hello Experts.
I have an SSIS project that has an Execute Task, which calls a stored procedure.
The stored procedure has a number of elements to it and takes a long time to complete.
...
I have data in a column called State each state is inside double quotes such as "Maine"
and I want to remove the double quotes so that it is just Maine without double qoutes.
How do I ...
Dear Experts,
What is the fastest way to transfer data from tables (views) between two SQL Servers ? By using linked servers - distributed transactions, SSIS packages, replications or somethi...
Hi,
I would like to schedule a SQL job which it would include a few steps.
1. run a DTS job I created, which would query the tables for some output
2. put the output in an excel file
3...
Hi,
Can anyone please tell me how to import text file in SQL 2005 64bit using BCP utility?
Thanks
Is there a way to call a dts and pass parameters to it.
we have written a DTS package on one server for one client, and want to use the same DTS package on another clients server, but the s...
Hi,
I need to create a csv file from a DTS package containing header and detail row's which contain a different number of columns. The header must be followed by the order lines for that orde...
I am trying to run an Execute SQL task in a DTS package that requires a parameter that is held as a global variable. The package is called from AutoCAD and I have successfully checked that the...
Hi Experts,
I have table1(coming from access db) table2 coming SQL db.
I have a transform task in my DTS package to add the needed records to Access table
where the source is a query based ...
SQL Server 2000.
Hi
I have an active x vb script in a dts package which calls windows shell to unzip a WINRAR file. the problem is that the dts package returns "successful completion" while...
I am using script component in the SSIS and vb script
I am getting this error.
The value is too large to fit in the column data area of the buffer
Any help is really appreciated.
Thanks
Hi Experts,
I have a flat file source like this.
"ES";"ITEMGROUP";"299919088880";"Reusable Other";"Standard";""
I've created in SSIS a flat file connection in connection manager with this...
SSIS Script task within a package with a connection named Conn,
How do I pick up the name of the connection in Sub Main() of Class ScriptMain of the task?
I know there is a connection coll...
Hi all.
I have a DTS that runs weekly, the DTS consists of an ActiveX Script, it looks at a View, it then creates an email and populates an HTML table with the results from the view. That's...
I am working on a DTS package that imports a text file daily. The text file that has to be imported is fixed width, however, each record in the file spans 7 lines. Each line of data has a li...
I have a .csv file to import into a table in a MSSQL database. The problem is the .csv file is just one columns with about 4 different fields all separted with a series of spaces.
Example
...
using SQL Server 2000, in a dts package when I create a connection object, if I type in the full address of the named instance including port I can connect without any problem. However, if I t...
Greetings.
I need some help in this issue: It's possible when you execute an ActiveX script inside the DTS Package (import a text file to a sql table) to ignore the last line inside the fil...
I have a DTS package that imports a text file into a table. I have a stored procedure that uses xp_cmdshell to run the DTS package using a dtsrun command line. My user is the creator of the ...
Using SQL server 2000, if you add a "send mail" task in a DTS package, what profile and service does that task run under? I am running into what I believe is a permission issue with a failing...
i have created a DTS that extracts data from MSSQL into three different files that i use,
now i am required to append those three files into 1.
could someone please tell me how to do this ...
Hi!
I have a Windows batch file that exectues BO 6.5. The text of the batch file is here
"C:\Program Files\Business Objects\BusinessObjects Enterprise 6\bin\busobj.exe" "C:\Busi...
Hi all,
I want to export data from a SQL database table to a Access database table. However, I want the Destination table to be cleared everytime before the exporting takes place. Can anyon...
I have a DTS task (which is a one-step ActiveX VBScript) which reads our database to send data to a business partner via XML. I have setup a job in the SQL Server Agent to start this task ever...
