|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Session Variable in DTS Posted by TaHir at 8/14/2006 9:45:02 PM hi,
i am using SQL server 2005, can i use a session variable in DTS package.
i am importing a Text file, i have a field ("USER_ID") in the database table
that which user has imported the file. how can i achive this.
THanks...more >>
SSIS .Net Provider Output Task Posted by nite_eagle NO[at]SPAM hotmail.com at 8/14/2006 12:36:06 PM I am working on performance improvements uploading to Oracle. The
performance of the Oracle OLEDB provider and MS Oracle OLEDB provider
are really poor. 12 minutes to load 50,000 rows.
I want to see how the .Net Provider for Oracle performs.
I have started to create a SSIS package. I have cr...more >>
SMTPMail Task Posted by putrevu at 8/14/2006 10:07:23 AM http://www.sqldev.net/dts/SMTPTask.htm - this tool is simply superb,
using which we can send mails with out using MAPI.
My question is..is there any option to dynamically set the properties
of MULTIPLE tasks at a time.
For one SMTPMailtask, using dynamic properties task we can set the
prope...more >>
Very large CSV Files Posted by cheesey_toastie at 8/14/2006 3:52:35 AM Hi,
I wish to create a DTS Package to output to a csv file. Finger in air
maths suggest the csv file is likely to be 7GB. Is there any limit to
creating such a large file? Any ideas how long this would take?
Thanks for any pointers.
Steve
...more >>
SSIS Package Configurations after Deployment Posted by Charles Kangai at 8/14/2006 3:34:02 AM I have deployed and installed an SSIS project with a package configuration. I
installed it in the msdb database. When I execute the package in Management
Studio, I am having to tell it again where the dtsConfig configuration file
is. Otherwise it executes with the last saved values in the pack...more >>
SSIS Processing flat file with multiple record types Posted by TimS at 8/13/2006 10:11:26 AM Hello, I am a novice with SSIS and have only used the DTS wizard to create
DTS packages. That being said, I was wondering if it is possible, and how
hard would it be to use SSIS to process a flat file that:
Is not delimited - is positional
Has multiple rows per object - a customer "record" ...more >>
Sequence of nearly identical tasks for different tables Posted by Nils Magnus Englund at 8/12/2006 12:00:00 AM Hello,
I'm just starting to use SSIS, and I would appreciate some help on my
current challenge...
I have 20 source views I want to fetch data from, and insert them into 20
nearly identical destination tables in another database. The destination
tables have the same columns as the source ...more >>
DTS Import puzzle Posted by Peter Croft at 8/11/2006 5:30:25 PM We run an ASP website with an MS SQL Server database on a third party
server.
Last night it was hacked and data in one table, called Entry, was changed.
I exported the database to my local server (as local1) and corrected the
data changes.
I then tried to import it back to the remote server and...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Migrate DTS Package from SQL Server 2000 to SQL Server 2005 Posted by Luis I. Gomez at 8/11/2006 2:54:26 PM I have a fairly complex DTS Package written in SQL Server 2000, are there
any pointers in how to convert/upgrade this package to work with SQL Server
2005?
I haven't started the move yet, but want to be prepared.
Luis
...more >>
Importing DTS package to a SQL2000 server from a .dts file Posted by Big Ern at 8/11/2006 1:51:02 PM To all that might be able to help -
I was given a few DTS packages from a SQL 2000 server and need to import
them into one of my SQL servers, but I'm not sure how to go about that when
it is a .dts file. Can anyone help?...more >>
SSIS Package Execution Failed within ASP.NET Web Application Posted by Tina at 8/11/2006 11:00:01 AM Hello All,
I have a SSIS package which run well when stand-along. However
it was failed when executed from .NET web application. It just simply return
Failure into the DTSExecResult variable below:
Dim packagekgResults As DTSExecResult
..........
packagekgResults = package.Execute()
...more >>
export table to excel file Posted by florian at 8/11/2006 6:31:11 AM hi,
is there a way to get the data of a table exportet to excel?
thanks
...more >>
loading Excel Files Error Posted by florian at 8/11/2006 2:17:54 AM Hi,
I encountered the following error message when running a dtsx Package -
which should insert the values from an Excel Package to an SQL Server
2005 table:
SSIS package "Dim_onetime.dtsx" starting.
Information: 0x4004300A at load Dim_Stay_Duration, DTS.Pipeline:
Validation phase is begin...more >>
invalid transformation Posted by Irene at 8/10/2006 4:46:05 PM Hi, I am using a DTS designer to convert a database. In the transform
data task, I am using "active-X transformations". Now, If I make
changes in the destination database structure (table structure), I
cannot access the script anymore, because the only options are:
- "change sourse and destinat...more >>
Error only when running as a sub-package Posted by Pat at 8/10/2006 9:57:01 AM Windows 2003 x64
SSIS 2005 x64 SP1 + hotfix 918222
I have a number of packages that import csv files from various sources. When
I run these packages independently from Visual Studio using "Execute
Package", they work fine.
I need to have them all run in sequence, so I created a super-pack...more >>
Connection2.ProviderID values Posted by Sandrina at 8/10/2006 9:52:48 AM
I'm programming a DTS, and I need to specify a Connection2 object. Now
my problem is this - what are the values for the ProviderID property o
the Connection2 object? I can't seem to find them anywhere....
I need the values for a SqlServer database, for a text file and Oracl
database
--
Sand...more >>
VBA to VB in DTS ActiveX Posted by Stephen Lonsdale at 8/10/2006 9:49:01 AM I am using the VB code below in MS Access to insert a record in a SQL table.
The code works fine.
I now want to move this code to an ActiveX script in DTS (SQL 2000) but get
errors when I Parse the code. Can anyone please expain what I'm doing wrong?
many thanks
Stephen Lonsdale
...more >>
data flow Posted by dana at 8/10/2006 7:14:20 AM hi , i have two qustions
1. is it possible to use parameters in the data flow area of sql server
2005 dts?
if yes how?
2. how can i execute an insert command that get the values from a
global parameter - an object type taht now contains a recordset.
thanks dana
...more >>
partnumber as string subtracts Posted by j.eeuwijk NO[at]SPAM tycoelectronics.com at 8/10/2006 4:51:45 AM Hi,
I'm trying to write a DTS package that sends some partnumbers from one
table to another. The partnumbers are something like xxxxx-y, so for
example you could have 12345-6.
When I insert the partnumbers into the new table, the following
happens:
Instead of 12345-6 I find in my table the v...more >>
How do I choose which execute job task to run, within a DTS? Posted by Ben Carlson at 8/10/2006 4:13:02 AM I am trying to write a DTS which runs one of two different DTS scripts
depending on the data in one table in the database.
I think I am looking for an "if" or "case" type statement... is there such a
thing? Do I have to break down and write VB?
This is on Windows 2000 with SQL 2000.
Th...more >>
Pass User and PW in a dtsrun batch file Posted by David C at 8/9/2006 11:49:01 PM Hi,
Is it possible to pass the username and password in a dtsrun batch file??
I want a few users to be able to call a batch file that runs a DTS package,
these users do not have enterprise manager. The batch file works fine when
run on the server.
I am using the following code so far - ...more >>
Configure a DTSDataDrivenQueryTask with ActiveX Posted by Michel at 8/9/2006 10:53:28 PM Hi I have a question about how I'm able to configure a
DTSDataDrivenQueryTaks.
My idea is, that I create a DTS Package with the enterprise manager. there i
have an active x script and the DTSDataDrivenQueryTaks. Before I run the
DTSDataDrivenQueryTaks, I run the active x script to configure...more >>
How to skip the Violation of PRI KEY constraint error in a DTS pac Posted by Chin Lin at 8/9/2006 7:37:01 PM Hi:
I am new to SQL server. I need to import data to my SQL database
periodically. The external data may contains duplicated data to my database.
I was using "Import data" initially but it will fail if there is a violation
of PRIMARY KEY constraint.
Then I discoverred this DTS package wh...more >>
Passing global variables on command line to DTS package in SQL Server 2005 Posted by djyoda at 8/9/2006 12:45:35 PM Hi,
I need to pass a global variable on the command line to a DTS package
which is stored in the SSIS Package Store, when i run the command, i
get this message:
dtexec /DTS "\MSDB\testpackage" /SERVER
server123 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET
"\Package.Variables[testvariable1...more >>
Accessing DBF files remotely. Posted by Pascal Dorion at 8/9/2006 10:41:02 AM Hi,
We have a Vantive CRM running on SQL Server 2000 in Chile and we need to
access DBF files on a server that also runs SQL 2000 in Peru. How can I get
the SQL server in Peru to access the DBF files and then the Chilean server to
get the data from the Peruvian server? The idea is to get bo...more >>
passing parameters Posted by dana at 8/9/2006 10:10:05 AM i'm quite new with all ssis,
i need to transfer data from sybase to sql server 2005,
i need to perform this task cauple of time a day, therefore every time
i need to transfer only the delta. (somting like replication).
so i thought about using the ssia - data flow -
i wanted to make a query on...more >>
SQL Task: Insert statement with input parameter Posted by Ric at 8/9/2006 8:51:03 AM Hello, I want write an insert statement in a SQL task that I would like to be
able to pass an input paramter. For example:
insert into TableA (col1, col2)
select EmployeeID,?
from employees
where .........
Another variation
insert into TableA (col1, col2)
select EmployeeID, employeen...more >>
Skipping Rows With Bad Data Posted by BradR at 8/8/2006 6:32:29 PM As I process a text file, I need skip rows that that have missing data.
I added the following row transformation script, but it causes every
row to be skipped.
Function Main()
Dim missingFields
Main = DTSTransformStat_OK
missingFields = ""
if IsNull(DTSSource("Address1")) or trim(DT...more >>
DTS in 2005. Posted by Jeremy Chapman at 8/8/2006 4:09:24 PM DTS is listed under Legacy in 2005, is there a replacement?
...more >>
database structure to Foxpro Posted by aamirghanchi NO[at]SPAM yahoo.com at 8/8/2006 1:31:52 PM Hi,
is anyone aware of a way to export a sqlserver 2000 database structure
(not data) to a foxpro dbf.
We dont have foxpro installed on our system.
Thanks.
...more >>
My job fails when it is scheduled??? Posted by StuartGMilton at 8/8/2006 7:06:07 AM Hey folks,
Why does my job fail when it is scheduled, but works perfectly when run
manually?
I've even changed the owner to 'dbo', and tried scheduling it as 'sa'?
But it still doesn't work?
Help.....
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |