|
|
|
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 Data Link support for Data Transformation Services Posted by jayl via SQLMonster.com at 12/21/2006 3:06:41 PM Hi All,
I am looking to use DTS to manipulate data from a number of sources (access,
oracle, etc.) and am looking for some direction as to best practices and
gotchas that I should worry about. Do people recommend using DTS or is there
a better way of doing this type of data import/manipulatio...more >>
Data Driven Query Problem Posted by Kurt at 12/21/2006 9:33:30 AM Hi,
I've got a big problem with SQL Server 2000 DTS and I hope that you
could help me.
I'm making a package (PKG A) calling an another one (PKG B) using =E0
Data Driven Query. When I run PKG B alone it works perfectly and there
is no problem, that's perfect. But when I run it from the PKG A I...more >>
Simple Question on DTS - Please help me .. Posted by karthik at 12/21/2006 6:42:23 AM Dear all,
Using DTS i'm transferring 3 tables (Just select * statement ) from
database A and loading the 3 tables to database B repectively .
I need the tasks to be set like this:
1) There should be only one source and one target in the dts designer
sheet .
2) Every time before i load the d...more >>
Problem using Excel named ranges within a DTS package Posted by dcrawley at 12/21/2006 3:41:13 AM Hello
I am importing data from an Excel spreadsheet into a table, via DTS. I
am trying to use a named range in the spreadsheet, and have used a
script from Allan Mitchell to achieve this:-
' 243 (Excel Named Range)
Option Explicit
Function Main()
Dim sActualLocationOfData
Dim Exce...more >>
Cancel SSIS package programaticly Posted by Ralf Hedler at 12/21/2006 1:11:00 AM Hello,
we execute packages from our windows-application. Some packages take a long
time. Is it possible, to cancel packages programaticly?
Would be very happy for any comment!
Best regards
Ralf Hedler
...more >>
Multiple Workflow execution of Tasks Posted by tturner6 NO[at]SPAM hotmail.com at 12/20/2006 8:40:29 AM I have written many DTS packages to move data, I've never had to branch
in my workflow of tasks.
I'm creating a package which has a log table. It runs four times a
day. It will check the log table, if the package has already run,
stop. If it hasn't run, go on with further processing.
I'v...more >>
Data migration from Mainframe to SQL Server Posted by cjeffwang NO[at]SPAM gmail.com at 12/19/2006 8:05:01 PM Is there an easy way to migrate the mainframe databases, e.g.
ServiceCenter P4 or Model 204 to SQL Server. In general, they all can
be called relational databases, but the data can not be migrated easily
by using the database utility tools. Other than transfering to text or
Excel, then to SQL ...more >>
SSIS Package runs in VS but not on schedule Posted by Svein Terje Gaup at 12/19/2006 1:44:28 AM I have a package that transfers data from a table in SQL Server to a
table with identical schema in Oracle. This package runs fine when run
from Visual Studio, but it fails when I set it up with a schedule in
SSMS.
Error message is:
Execution of job 'Eksporter til Formula' failed. See the hi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS: Oracle to SQL Server transformation Posted by Fariba at 12/18/2006 9:08:00 PM I have to come up with a SSIS package to tranform data from oracle database
to our sql server database. This oracle db is managed by a third party , I
have been given 10 views from oracle so I can extarct information I need.
How should I design my SSIS package? Do I have to have 10 different ...more >>
Dynamic setting of Destination in Data Transformation Task Posted by Blake at 12/18/2006 3:41:51 PM Call me stupid, but I need help.
I'm converting from a Dbase5 file to SQL database. I have a "dbase5"
connection for the source database and a "OLE ..SQL" connection to the
destination database. Between the two connections I have a Data
Transformation Task. I have a global variable called "...more >>
SSIS Error: Failed to lock variable xx for read access - Script Task under Foreach Container Posted by jobs at 12/15/2006 11:46:20 AM Perhaps somebody in this news group knows.
In SSIS
I have a foreach container thats got an filename enumeration collection
of files in a directory stored in a variable I call FileName.
Inside the foreach container, I have script task (vb.net) that I want
to pass that FileName variab...more >>
SSIS Export to iSeries table Posted by Helmut Knappe at 12/15/2006 12:00:00 AM Hi,
I am asked to help a customer writing data to a table on an iSeries system.
There is no ODBC source nor target in SSIS. But he can read using the
DataReader Source via ODBC.
But for writing? The DataReader Target only goes to memory. And what I am
supposed to do then?
Isn't there...more >>
import a text file from a remote server using A DTS package Posted by bj at 12/15/2006 12:00:00 AM Ive tried several ways to create a DTS package to import a text file into my
SQL database from a remote web server (ip address).
When i walk through the text file wizard I've tried the following paths for
the connection but it keeps failing. My permissions on the webserver are ok
because yo...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |