How to determine folder from one month ago.
Tue, 2 Sep 2008 14:49:01 -0700
Hi,
I have a DTS package that is run once a month using a text file sent to us
by our customer. Each month we get a new data file and it's placed in a new
folder with the current date. The format of the date is YYMMDD. So for
instance the August file was placed in the folder created and named as 080806.
...
|
SSIS 2008 and MOSS 2007
Tue, 2 Sep 2008 05:41:11 -0700
Does exist a simple task (or manner) to export data from a MOSS list to a SQL
table by using SSIS 2008?
Thanks ...
|
Uploading German characters from Excel sheet using DTS package
Mon, 1 Sep 2008 08:54:01 -0700
When trying to upload German characters from an Excel sheet to a database
table using DTS package the following happens:
Characters can be read in the Excel sheet. After uploading, the characters
cannot be read from the database table. The characters are replaced by a
square.
Does anyone know what I shou ...
|
Automatic Status Report
Mon, 1 Sep 2008 06:52:01 -0700 (PDT)
Dear All
I am going to develop a routine which will send a status report of a
sql server as an xml document. The document will include a list of the
databases on the server, a count of registered logins, status of the
executed agents etc etc. The reason for this is to create a single
portal which will display ...
|
Error 29549 during SSIS 2005 install on a cluster
Mon, 1 Sep 2008 03:27:01 -0700
I'm adding SSIS 2005 on two node cluster. I'm using SQL Server 2005
Enterprise Edition 64-bit.
In the first node I have added correctly SSIS: I have launched the RTM setup
and then applied the SP2.
On the second node I have obtained this error: Product: Microsoft SQL Server
2005 Integration Services (64-bit) ...
|
Why SSIS so troublesome in VMWare?
Fri, 29 Aug 2008 17:53:00 -0700
Hi experts
Hard time always arise when deploying SSIS package at Vmware.
At Vmware, the connection string configuration is not able to read from the
designated location .dtsConfig file eventhough add at Configuration page
before executing.
At non Vmware, the same package and same steps taken, the packag ...
|
Exporting SQL Server to Access
Thu, 28 Aug 2008 18:16:00 -0700
Is there a tutorial on the easiest way to export an SQL Server database's
tables into and Access database (all tables without having to do them one at
a time) in a package that runs daily?
Thanks. ...
|
|
|
Microsoft Data Link
Thu, 28 Aug 2008 14:29:01 -0700
Easy question for the folksâ?¦
I have a SQL Server (2000) with .txt data files that I need to send cross
country to another SQL Server. This needs to be a scheduled job to run each
week. My thought was to use a DTS package with a Microsoft Data Link but Iâ??m
not sure. I cannot find examples of the â??UDL Fil ...
|
Why Add ConfigFile location?
Thu, 28 Aug 2008 09:26:01 -0700
Hi experts,
i just realize the SSIS Execute Package utility has one feature to allow
manual add ConfigFile location for overwriting the default location.
however, the program seems not working although manual add the location.
May i know why and how to change the ConfigFile location to a new location?
...
|
why SSIS xml deployment has problem?
Thu, 28 Aug 2008 08:21:02 -0700
hi experts,
i use xml configuration with no password protected n tried to deployment at
server side, but fail.
When run the package, it stated error :C020209 on certain connection not
able to retrieve although i dedicated the connection properly.
Why so many problem in deploying the SSIS.
please advi ...
|
