I'm trying to get my DTS packages converted over to SSIS. I have a package that has a datetime field that when converting to a text file needs to be in a format of MMDDYY. Simple in DTS, but...
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...
I have the following code in a stored procedure called by a DTS Execute SQL Task:
-----------------------------------------------------
-- Error handler for Errors encountered
ErrorHandler:...
I have a table that keeps track of trucks going in and out of our yard...sometimes (because the guards are lax) they will enter the same truck twice...so, at the end of each week I go and find...
Hi,
We are using SQL Server 2005, and I like to know how can I deploy a SSIS.dtsx package on the server and schedule the job to run the package?
Thanks,
OK...before you guys say anthing, I've got a Proxy that runs the package as the exact same user I use when I log in. So I don't think it's a permissions issue, That being said...
In my Exe...
Hello Experts,
I have developed an SSIS package on my production machine and ran it with no problems.
However, when I schedule the package to run (and set ssis logging on), I find that ...
Running Sql Server 2000 on SBS 2003 premium fully patched.
I have a fairly large text file filled with comma delimited data. I need to read it as fast as possible.
I am not an fso expert....
Hi
I am exporting data from SQL server 2000 table to a CSV file using DTS.
One column in particular is giving an issue.
It is a serial number column - it can have mixed data types - eg; n...
what is the simplest way to send email through a webserver (has windows 2000 server installed and running Ms Outlook as email client) that has Ms Sql server 2000 through sql server by specify...
I have a third-party application that uses a MSDE database. I cannot change how this app functions but I have written some web apps so that our web users can still interact with the data. No...
Okay, I'm reposting this because I never got an answer and I REALLY an answer to this. Please help.
_____________________________________________________________________________________'
...
I have a flat file fixed length that I want to output to multiple tables. In essence I have a unique id in each row and I need that id to go into maybe 5 tables and then portions of the rest o...
We defined some DTS packages and set up linked servers in SQL 2000. Now we migrated our
databases to SQL 2005. How to move all DTS packages to SQL 2005 server? SQL 2005 doesn't use DTS packag...
Hi All
I have a SQL2K db and an A2K.mdb, both have the same schema.
(The mdb tables were the 'source' of creating the SQL tables.)
I need to do an INSERT of all records in all tables ...
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...
Hi all,
I tried using the following code to automate an ftp upload:
exec master.dbo.xp_cmdshell 'cd D:\inetpub\ & ftp -s:froogle.txt "www.mysite.com " & [myFTPusername] & [myFTPpassword]...
Hello~
I need to take a stored procedure in SQL Server that takes data from multiple tables into a temp table then at the end of the procedure selects from the temp table. and use DTS to ex...
I need to remove duplicate data within a row (not duplicate rows). For example:
I have two columns, ID and NUM, [ ID is one to many NUM].
Their are "some" data sets in the NUM column th...
I am using SQL Server 2000. I have created an excel file using the Transform Data Task to an excel file. After the file is created, I send an email using ActiveX with the file I just created...
I'm attempting to update existing records that are already in a SQL database through an Active X Script in SQL using VBScript. I do not want to add new records, I only want to update specific ...
When I use VB.Net to do ADO I create a SQLConnection in the project and the assign a connection variable to it. Such as sqlConn = me.SQLConnection1. In SSIS I can add a connection to the conn...
Hello all,
I have a MSSQL 2000 database that I am migrating to a new server box with SQL 2005 installed on it.
This is my first attempt at something of this nature. I moved the Data and User...
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...
How do I run a dts package from Query Analyzer? What is the syntax? Thanks.
