|
|
|
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 Upgrading from 2000 to 2005 (DTS) Posted by Blasting Cap at 9/14/2007 11:44:59 AM I have 2 production servers which operate in conjunction with each other
(i.e. one will update databases & tables on the other). They're both
Windows 2003, SQL server 2000, most current service packs on each.
I've run an upgrade tool (inquiry) on them, and it ID's a few stored
procedures t...more >>
Using a variable in DTS Script Posted by at 9/14/2007 5:37:48 AM I'm trying to help a coworker with a DTS package. I mostly use VBA
and don't know a lot about DTS. What he had was a hard coded line
like this
DTSDestination("Aug 07 VS Sales") = DTSSource("Aug 07 VS Sales")
and the date was always for the prior month. I came up with some
VBScript to c...more >>
Best practices w.r.t. use of Stored Procs in SSIS Posted by B NO[at]SPAM ns at 9/13/2007 5:08:04 AM Hi,
I need to know whether it is good to use a Stored Procedure in the Execute
SQL Task inside a SSIS package or whether the functionality of the SP should
be emulated using the SSIS tasks and transformations.
We have some DTS packages which are calling a Stored Procedure to do all the
t...more >>
make a job successful Posted by Lhoussain at 9/13/2007 12:00:00 AM How can I make a job successful when it contains a DTS package that
transfers data from a text file to a SQL Server table and updates the table?
The problem is the job should run daily but the file may not always be there
:
Function Main()
Dim oFSO, sFileName
sFile...more >>
Cannot create COM Server to load and execute DTS Package Posted by ARUL at 9/12/2007 3:20:01 PM Hi,
DTS job fails with the following error, A Server (Windows 2003 SE with SP1)
has 4 SQL Server 2000 instances with mixed of SP3 & SP4. But few jobs are
failing in all the 4 instances.
Executed as user: DCADB04\SYSTEM. DTSRun: Cannot create COM Server to load
and execute DTS Package. ...more >>
SQL Server 200 DTS Package Posted by pad at 9/12/2007 11:23:27 AM I have a Package which can process any number of files and after processing each file it Archives the Processed
file in the Archive Folder.
I cannot reprocess/Import the same file again(in case by mistake)
to avoid this i need to put a check before each run to check the archive folder with the in...more >>
SSIS Execute Process Task Posted by H Jackson at 9/11/2007 5:40:32 PM When I first create a package that contains an Execute Process task which runs a batch file, it runs without any errors. But if I run the same package a day later, it fails with the following error: Error: 0xC0029151 at Extract Discoverer Data, Execute Process Task: In Executing C:\ora\bat\NetDirec...more >>
SQL Profiler Posted by bb at 9/11/2007 12:04:03 PM How long can I run the profiler to get trace from the production server. It
should not degrade the server performance. what is the minimum time to run
the sql profiler to caputure all queries in the trace
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS Derived Column YYYYMMDD to MM/DD/YYYY with Nulls Posted by Zach.Baier at 9/11/2007 6:44:00 AM I have a fixed length (ragged right) flat file with several dates in the
format YYYYMMDD which I am trying to load into SQL smalldatetime fields.
I have set the input for the fileds at a width of 8 (dt_Str) and output
width of 10.
I have added a single derived column data flow element and sp...more >>
Results to Variable Posted by Pasha at 9/10/2007 1:06:02 PM Hi All,
Here is my scenario:
I execute a Data Flow Task, that returns only 1 row and one column. I would
like to assign that result to a variable. Then, based on that variable (or
result), I would like to execute either Data Flow Task 2 or Data Flow Task 3.
For example, if the result ...more >>
Records not importing, but no error Posted by JoelB at 9/10/2007 11:14:06 AM I have a DTS package that imports records from a fixed-width text file into a
table with matching columns. There are about 500,000 records to import, but
after "successful" completion of the package, only 288,000 records have been
imported.
I located in the text file one of the records t...more >>
SSIS - dtsx package works in debug mode, nowhere else Posted by Greg Toronto at 9/10/2007 9:34:02 AM Hi there...
I'm fairly new to SSIS, and am having an interesting issue.
I have a fairly standard package, it:
- Imports a table
- Runs a query
- Exports a Flat File
- Zips the flat file using a comand line process
- FTP's that File to my server.
If I run the package in debug mode...more >>
Modularization of Emails on Failure (DTS not SSIS) Posted by tech101 NO[at]SPAM gmail.com at 9/9/2007 7:12:27 AM In a DTS package, it is a laborious task to connect an On Failure
Workflow to a different Send Mail Task for each task (major or minor).
I am trying to do some researching on a single effective way of
sending an email with a description of the error and the job->task
that it belonged to.
What...more >>
Easy SSIS question ?? Posted by ChiWhiteSox at 9/8/2007 9:42:01 PM Hi All !
im kinda beginner in SSIS and any help will be really appreciated !
we have 2 separate DAtabases and each DB has a common table , lets say
Tracking Table. In DB1, Tracking has columns that has varchar datatypes, and
at DB2 it has same columns but of INT datatype.
Basically, eac...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |