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 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...
This should be easy because I'm sure it's an everyday kind of task. I've just never had to do it before. I am using an .adp project with SQL Server 8. A couple of months ago I made a copy o...
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
Here is my code:
SELECT
MEM_ID
,GRP_FACT
,CAST(REC_NUM AS DECIMAL(9, 2)) as REC_NUM
,CAST(GRP_FACT_CNT AS DECIMAL(9, 2)) AS GRP_FACT_CNT
FROM t_OUTR_REC_CNT a
where MEM_...
I have a question. we send out bank a text file daily that we create withour SQL server. Now the problem is to create that file I DTS a table. And if that Table does not have any records I get...
There is a daily job that executes a DTS package that imports a flat file into a table on a SQL SVR 2005 database. When the DTS package executes, if the daily file is empty it abends.
...
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...
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 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. ...
Hello,
I have few question about SSIS
1)I am trying to transfer data into SQL in SSIS project.
I can successfully transfer data into new table. However date/time in text file is not bei...
hI
I am moving huge volumes of data from a dbase file to SQL Server using DTS. The table into which the data is moved contains a clustered index and 2 non-clustered indexes. My problem is t...
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 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...
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...
I am getting the following error when I execute my sql task:
An error occurred while assigning a value to variable "NullVar": " NO result rowset is associated with the execution of this que...
Help me!
I use SQL server 2000, I created DTS and keep them in local packages what can i do if i want to back up these DTS like a backup database
Thank you in advance
somchai_edp
I'm tryng to generate a text/csv file from a SQL Server DB using Access 2003 frontend
I've read a few forums and i'm still finding this a little confusing.
I have created a DTS package whi...
I am getting into DTS to do more than just simple import/exports. What I want to know is whether it is possible, within the package designer, to actually create an Excel spreadsheet that I am ...
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...
Could you please explain me the process of how to move DTS packages and stored procedures from DEVELOPMENT environment to PRODUCTION environment?
Thanks!
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...
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...
