I am writing an MS Access 2003 application which needs to execute a DTS package on the server from a client machine.
The following code attempts to execute the LoadFromSQLServer method on t...
Hi Experts,
I have problems running a simple activex Script in a SSIS Job.
The Script:
'**********************************************************************
' Visual Basic ActiveX S...
Hi,
I have this store procedure. where I first created a Merge temp table. filled the table with data then I get the MaxNum the count. I am having problem with do while loop I want to say...
Bit of a conundrum here. SQL server management studio has a generate scripts function that allows you to script any operation that it performs, except one. It doesn't offer the ability to scri...
I have an activex step which i will determine if a file exists. If the file does not exists then i return failure else success. if failure i have a workflow link set to go on to another step "...
It seems like the only way to modify a (ODBC type) Connection Manager's password property is by creating and employing an XML Configuration file to which you can store, and from which you can ...
I have some dts packages that I need to make sure they work in a Sql server 2005. The client just sent the dts files. A bunch of interfaces use these packages to dump data out. I would appreci...
I am exporting about 14 Million records from SQL2005 to Oracle (8). I am using the Microsfot OLE DB Oracle connection is SSIS. The job has failed on me about 3 different times. I get up to ...
I'm in the midst of creating my dts packages for data export and I would like to know when I choose for "Microsoft Data Link" in connection properties, what should be written in *.UDL? sorry n...
Hi All
I am extremely new to DTS and would like to know whether I can use DTS to execute an ASP.NET page on a scheduled basis?.. I am using SQL Server 2000 and ASP.NET 2 VB.
If this is pos...
I am looking for information on DTSX...
1. How it is used.
2. Good sites to go to.
3. Good explanation on how it is used
I am having an issue when scheduling my DTS package. I try setting to run m-f at 4pm, but it always sets it to run at 12:00am. Nothing I have done will change this.
I then tried setting th...
Several DTS packages that take SQL tables, converts to access data by dropping the access view, running a SQL script and copying over...
Can't figure out how to copy those over to run against...
Im trying to copy a table from SQL Server 2005 standard to MySQL 5. Ive tried right clicking on the database in MSSQL and going to tasks and trying to export that way but there is no provider ...
I need to validate a field by testing if the date is greater than today.
I tried using a conditional split with an expression of [datetocheck] >= Getdate()
but it doesnt seem to work
I am generating a file name based in current date and sequence number depending in how many files have been generated in the current date. Along with the current date in the file name also I a...
Can a SQLExpress database ssis package be created or managed through SQL Server Management Studio? Do you need the designer (Business Intelligence Development Studio) to create a package or ca...
I upgraded our production server to SQL 2005. I had several DTS jobs that had Analysis Services cube refreshes in them. However, even with the DTS conversion tool package loaded, when I run ...
Hi all, I am trying to use a DTS package to move a worksheet to the first of my workbook. I can do this in VB with no problem, but DTS doesn't like this command.
objExcelMaster.Worksheet...
In ms sql database we are querying database from 25th april to 26th april and getting 50 records.
However when we are querying from 25th April to 25th April we are getting 0 records
, when...
Hi Guys,
I current have 418 delimited DAT Files that come through nightly as a backup from one of my systems. Of these 418 files, I manually DTS in 50 of these a week. I have attempted to s...
Trying to create a stored procedure that could run on SQL Server Agent, or a DTS package.
On day 1 of each month, create a new table, with the same structure as last month's table.
Old tab...
Hello
I've just been setting up a DTS job in VS integration services.
I'm now trying to save the package to a SQl server 2005 on another machine.
I am able to access the package loc...
I have a table with a field called LNFN. What query would I use to find all records where the LNFN's are the same? In addition, I need to create another table with all duplicate LNFN's (the en...
Hi, I need a T-SQL Stored Proceduer defined for MS-SQL 2000
The purpose of the Stored Proceduer will be to subtract 1 (ONE) from a stored integer in a field.
Here's the complete scenario:
...
