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...
DTS Import of flat (text) file / VBScript transformation (ActiveX)
Fld 20 Fld 21
- 00002500.2369
NULL 00000182.50
Fld 20 Positive / Negitive indicator
Fld 20 Number ...
I have a DTS package containing two global variables, FromEmailAccount and ToEmailAccount. (These variables are set at design time to normal looking email addresses.)
The package also c...
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 ...
hi experts,
I'm using SSIS "File System Task" to copy a folders content (several textfiles) to another sever.
My wish is now, to copy only those files over to the other server which are st...
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...
I've recently upgraded to SQL 2005. Using the legacy tools, I have a DTS package that I made changes to. Now there are multiple versions of that DTS package. In 2000, you could just right ...
Hi,
I would like to import several text file in SQL 2005 using bulk insert. Can anyone please tell me how to do it?
Thanks
I have created a DTS package in SQL Server that calls an executable. I have used the "Execute Task Process" in DTS to run the executable. When I run the DTS package manually, the program run...
I have some data stored in SQl Server 2000 that I'd like to export to an Excel spreadsheet. I would then like to format this data (using VBA if possible). This is a daily report that needs to ...
I need to develop a way to export specific tables out a SQL Server database into multiple text files (one for each table) and to be able to set this as a scheduled task. I know we can export ...
Hi Experts,
I have problems running a simple activex Script in a SSIS Job.
The Script:
'**********************************************************************
' Visual Basic ActiveX S...
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...
Hi,
Does anyone know what the syntax is to alter to IDENTITY column so that the new starting number can be changed?
I have tried:
ALTER TABLE CONTACTSOURCE
ALTER COLUMN LOAD_ID IDEN...
I have a SQL 2005 job scheduled to run nightly at midnight. The scheduled job fails. If I run the job manually it runs fine. If I'm logged into the server and have SQL Studio open then the sch...
DTS package was created in SQL Server 2k. The package runs an ActiveX script to check if a file exists in a directory. If so, it moves the file to a new location, creates the result table from...
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'm trying to run a SQL Server DTS package from the cmd promt using the DTSRun tool with the code
DTSRun S/ "Server Name" N/ test U/ username P/ password
But every time i try to execute t...
I need to register my server on SQL 2000 Enterprise Manager in order to use the Data Transformation Services to import / export tables (was using it before, but managed to delete the server in...
I have a stored procedure that runs a DTS Package with the following syntax:
exec master..xp_cmdshell 'dtsrun /Smyserver /NFile Import For 2011 /Usa /Pmysapassword'
It's supposed to impo...
Hi Experts,
Is it possible to include the execution of an autoexecute MS Access macro as one of the tasks in sql server DTS?
I would like to schedule the opening of the MS Access Databas...
I have a SQL 2000 DTS package.
In side the package I have an Active X Task (VBScript).
It looks to see if a file exists.
If Yes Main = DTSTaskExecResult_Success
else
***** wa...
When I am trying to get the dataset for an excel file using the following code, i get the error "external table is not in the expected format." This was working fine last week, happens now wit...
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
...
Hi, I have a DTS Package that run a executable file that generates a XML file. I would like to run it everynight and send it via FTP, so how can I do to send the XML generated file via FTP evr...
