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...
I am looking for a way to
1) Collect 10 columns of data (anywhere from 1-5000 records) from a SQL Table.
2) export this data to a flat file
3) Link this data back to it's SQL Table to mark...
Does anyone know if there is a simple tool for comparing .dtsx's? I'm trying to track down some small differences between versions...
Thanks,
Julian
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,
I have an unusual problem driving me nuts - I have a mailing database containing two tables, maillist and exclude. I am uploading a list of emails to add to the exclude list and then, ...
I need to append records from Oracle to SQL. On occasion a field may not be exactly right. An example is the Oracle table may have a field that is 10 characters long. The Oracle group may c...
A few months ago a DTS package was created that connects to a btrieve database via an odbc, and copies the data to several sql server tables of the same name. The btrieve directory that contai...
I have a CRM system (SugarCRM) running on SQL Server 2005 and I have Business Contact Manager for Outlook running also on SQL Server. I can if needed run these two dbs on the same SQL server....
We receive a flat file from a third party which we am inserting into a table using a Transform Data Task Properties. There is no unique identifier contained with in the file. When we insert it...
When executing DTS using stored procedure in SQL 2000 getting error: -2147024888
This solution is not new. It's been working OK for a long time and out of nowhere start generating this error.
I have several MAP files that I need to maintain to support some reporting from a small data warehouse. The problem is the data source for these map tables is a manually maintained XLS file. ...
Greetings,
I am looking for a tool that will allow you to migrate a group of DTS\SSIS packages all at once to a new SQL Instance. Are there any existing third party tools available to achie...
I am trying to delete multiple DTS packages w/ a script. I saw the solution listed on this site, but when I try that solution, I get the following message. Msg 2812, Level 16, State 62, Line...
I have a DTS job that exports a table to a formatted Excel spreadsheet. Even though the spreadsheet is pre-formatted as numbers, DTS converts them to text. Is there a way around this? I fou...
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...
I need to get values from sql for a specific item and summed quantity but for each customer
as one record. I would need to convert the orderdate to just the year
I'm hoping to get the fol...
Experts,
I have a field coming in from the Mainframe and it is a text field. It's format is yy/mm/ddhh.mm.ss. The user wants to see it in datetime format on the DB. I am using SQL Server...
I'm try to understands what is the diff between these?
<
/D[ts] package_path
(Optional). Loads a package from the SSIS Package Store. The package_path argument specifies the relative pat...
Could you please explain me the process of how to move DTS packages and stored procedures from DEVELOPMENT environment to PRODUCTION environment?
Thanks!
One of my clients has a scheduled job that runs a DTS package every day. Recently the job began failing. I set up error logging on the DTS package, and have included the error below.
I ha...
I want to dynamic control a table copy job. For that reason I have made two variables source and dest.
The job works with the variables, but I want to loop and read new source and dest from a...
Hi,
I created a SSIS package from the BI management studio and executed the package.
It passes through the flow chart (I see green, green and red).
On the data flow, the color of the bloc...
Good Morning Experts!
Here is my setup. I have a DTS package that I am trying to get to Email an XLS file. Everything appears to run fine, but I get an error when it comes to the Email p...
Hi Experts,
I have a DTS (SQL 2000) that has a connection to a text file on a remote server. Is it possible, in the DTS, to specify to login name and password to use in order to access thi...
I'm trying to incorporate a piece of code that I got from a different post on this site. It deletes rows from a worksheet within an excel workbook. The piece of code that is giving me proble...
