|
|
|
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 No Expression Builder for SSIS Posted by Ken H at 1/7/2007 10:17:03 PM I have a deskop at a client that does not appear to have the Expression
Builder installed. There isn't an elipsis for the builder on the Expression
row for variables, or anywhere else in VS on this box that I can tell.
I checked the installation options, and did not see anything for this tool...more >>
How to retrieve Value from DTS OLEDB Connection ExtProperty collec Posted by Jim Trowbridge at 1/7/2007 6:13:01 PM I have a DTS package using ActiveX to scan and record various properties from
one or more DTS packages.
As part of this, i want to retrieve the Value string from the Connection
objects - kept in Extended Properties.
I can retrieve the other properties from Extended Properties, but I get nu...more >>
speed of inserting to clustered/unclustered Posted by JXStern at 1/6/2007 7:11:21 PM Importing a text file via DTS into a newly truncated table with a
simple PK on an INT (not identity) column.
Watching the profiler, first it does the select for the datapump, then
it does a bulk insert. There are a few light transforms in-between.
We're inserting typically two to six millio...more >>
Ordering of columns in flat file (simple?) Posted by mgale1 at 1/6/2007 6:55:00 AM Hello,
I am new to SSIS.
I am trying to write a simple package to export data from some SQL 2005
tables and into a flat file.
In my data flow, I am using the OLE-DB data source and then the flat file
destination.
This all works fine except that I cant get the package to write the columns...more >>
SSIS - Date Data Transformation Posted by Conan Kelly at 1/6/2007 2:31:39 AM Hello all,
I'm brand new to SSIS. Other than going through the tutorials in SQL Server
Help/Books Online, I have not yet created a successful SSIS package tailored
to our own projects.
I have 7 columns (2 of which are date columns) in a CSV file. The 5 columns
are just going to be copi...more >>
2005 ssis - send mail depending on sql Posted by GeorgeM at 1/3/2007 5:43:00 PM My first attempt at SSIS and I need to send an email IF SQL has found
particular situation. I have it writing a text(flat) file of the necessary
extraction but can not see how to send the email only if something was found
and extracted.
Any assistance will be greatly appreciated, thanks, G...more >>
SQL Server 2000 DTS question Posted by myrights99 NO[at]SPAM gmail.com at 1/3/2007 3:39:22 PM I need help on VB Script or better way, what i am trying to do.
I have more than 75 TXT files & this all 75 TXT files consists &
follows naming convention like AAAAANames.txt, BBBBBAddress.txt,
CCCCCTellno.txt, DDDDDProduct.txt.
I want to IMPORT DATA from this files to SQL Server 2000 Databa...more >>
SQL Server 2005 Integration Services: Column Delimiter Not Found Posted by brucemccann NO[at]SPAM gmail.com at 1/3/2007 12:02:03 AM Hi
I am trying to import a .csv file into SQL Server 2005 via Integration
Services. Created the Flat File connection all OK and the SQL Native
Client OLE DB Connection but the import always fails at the same row
(120,000 odd) with the following error: "Error: The column delimiter
for column "...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Copy column with leading zero Posted by stefanjohansson_2005 NO[at]SPAM yahoo.se at 1/2/2007 5:12:55 AM I have a DTS package that reads data from SQL-Server and exports it to
a file using a TextFile connection. When I export numbers using the
Copy Column transformation I get leading spaces instead of zeroes. I
can solve this by using the ActiveX script transformation instead but
should I really ha...more >>
How to know which constraint was followed Posted by Konsulenten at 1/2/2007 4:17:00 AM Hi all,
I have a newbie question. In my SSIS package I have 2 sequence
containers, A and B. If A is successfull then B runs. If A is failing,
a mail-object sends a mail, and B does not run. If B fails, the same
mail-object sends a mail.
How do I determine in the mail-object, if it was the c...more >>
SSIS - process all files in an FTP folder Posted by Charoniv at 1/2/2007 3:23:01 AM How do you process all files in an FTP directory - similar to a for each loop.
I need to be able to download each file and move it to an archive folder on
the ftp site.
Might also want to do other things in between....more >>
SSIS for each loop set path from variable Posted by Charoniv at 1/2/2007 3:11:01 AM How do you set a path from a variable for a for each loop container to
enumerate the files.
I want to be able to set the path at runtime so that we don't have to change
anything between dev and prod.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |