Re: DTS Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: BigO <pgouellette@xxxxxxxx>
Date: 17 Apr 2007 09:34:14 -0700

On Apr 17, 7:12 am, BigO <pgouelle...@xxxxxxxx> wrote:

I want to set up a DTS package that will process the current version
of a txt file located in a directory. When i create the package and
the connection to the file, it works fine the first time the package
is executed, however after there is a new version of the text file
located in the same directory and the package is run again, the
connection still is using the old txt data. Is there a way to correct
this. It's tough to be a real newbie.

Found the problem

.

References:
- DTS Question
  - From: BigO

Prev by Date: Import excel to SQL Server 2000
Next by Date: Re: -1073741819 Error Code returned from dtexec
Previous by thread: DTS Question
Next by thread: Import excel to SQL Server 2000
Index(es):
- Date
- Thread

Relevant Pages

RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
... The master package template contains two sequence containers. ... I noticed that I had not connected my first sequence container to ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ...
(microsoft.public.sqlserver.dts)
Re: DTS Global Variable problem - type mismatch
... But the problem is that the package still fails to run. ... of the properties within the DTS and run it from there then it works. ... > reference to the connection I have in my DTS. ...
(microsoft.public.sqlserver.dts)
Re: create dynamic dts package
... In my reply I said that all this may not be necessary and you may be able to simply rebuild the Transform data Task in an existing package. ... Dim oConnProperty As OleDBProperty ... ' create package connection information ... Dim oConnection As Connection2 ...
(microsoft.public.sqlserver.dts)
RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ...
(microsoft.public.sqlserver.dts)
Re: DTS Package Connection Properties Access Error
... When a DTS package is designed the GUI ... shows Connection 1 as the source node, Connection 2 as the destination node ... If I design ... Then it is looking for a server connection that is not visible from your ...
(microsoft.public.sqlserver.dts)