|
|
|
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 SSIS - Error Messages when looping through Excel Files Posted by Conan Kelly at 7/13/2007 7:07:47 PM Hello all,
What's the trick to use a Foreach File in Folder loop when looping through
Excel files? I've gotten the loop to work with flat files before, but
doesn't seem to like Excel files.
I have 36 XL spreadsheets (one for each month over a time series) that need
to be imported into o...more >>
How to build a custom log provider for SSIS Posted by Jason at 7/13/2007 11:32:04 AM Hello, can anyone suggest info on how to create a custom log provider for
SSIS? In particular, I want to track the row count and duration for each
Execute SQL Task and Dataflow Task.
I've seen an example of logging using event handlers at
http://blogs.conchango.com/jamiethomson/archive/2...more >>
View SSIS package in SQL 2005 EM Posted by nkg at 7/13/2007 11:31:30 AM Is it possible to deploy and view SSIS packages as DTS in sql 2005 EM legacy
components.?
...more >>
SP input for Raw File Posted by Mike DeYoung at 7/13/2007 8:40:01 AM Hello All,
OLE DB Source executed an SP to retrieve data. Trying to send the output to
Raw File.
When editing the raw file task, "This component has no available input
columns".
When trying to save/close the edit window, "There is no selected column to
be written to the file".
Are ...more >>
Setting dynamic date to an Oracle ODBC data source Posted by RK at 7/13/2007 7:36:01 AM Hi Chaps,
I am developing a DTS package to import data from a remote Oracle database
into our SQl Server 2000 database. The connectivity to Oracle is fine and I
can browse all tables and preview them via the preview of a transformation
task. Instead of a Table/View in the Source tab page, I...more >>
Comma separation Posted by Dan at 7/13/2007 5:48:01 AM Here's the scenario:
1) Customers enter an image request on a website (free-form textbox)
2) A record is entered in the database as an image request (with
corresponding pointers for identifying the customer, datetime, etc)
3) The customer actually included several unique items in a comma-sepa...more >>
Data Flow Task - Converting DT_NTEXT To DT_STR Posted by lloyddsilva NO[at]SPAM gmail.com at 7/12/2007 6:31:52 PM Hi Guys,
I'm currently using SSIS to copy data from a source table, change some
of the datatypes and pump it into a destination table.
The problem I'm facing is with conversion of an NTEXT field to a
VARCHAR field in the destination.
What I'm doing right now is:
Step 1: Extract From So...more >>
record hash Posted by gremlin321 at 7/11/2007 2:26:02 PM i am trying to find a way to calculate record hash something like crc in
order to identify if record send to me is a modified record or not. for
example i have a record that has employee id, name, phone(in reality i have
to deal with tables that have over 200 columns). so if i have a way to
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need help to migrate DTS packages from SQL 2K to SQL 2K5 x64 Posted by Jaisol at 7/11/2007 10:17:54 AM Our team should migrated all SQL 2K DB's to SQL 2K5 x64 (64-bits version).
As part of migration we should migrate DTS packages. Almost DTS's are
simple, have not level of complexity.
We're following next steps to migrate them:
1. Connect to SQL 2005 server using SQL Management Studio from th...more >>
how to migrate all DTS packages from SQL2000 to SQL2005 in one go Posted by Tiffany at 7/11/2007 2:38:03 AM Hi
Need to migrate all DTS packages from SQL2000 to SQL2005. May i know how to
do it effectively. Also, to ensure all the transformations in the DTS are
intact.
Thank you
Best regards
Michelle...more >>
Copy SQL Server Objects Task Properties Posted by Q at 7/10/2007 3:40:00 PM Hello
I am using Copy SQL Server Objects Task to copy tables and data from SQL
server 1 to SQL server2, replacing the tables and data in SQL server2. Is
there a way to automatically check if all the tables I am copying in SQL
server1 have data before copying?
Thanks,
Q...more >>
SSIS - can SSIS pkg recognize a drive letter within SMS job? Posted by frostbb at 7/10/2007 9:52:36 AM Greetings SSIS gurus ...
Is there some way that SSIS projects can recognize a drive mapping when the
package(s) are executed from within a SMS job ?
The SMS job agent runs within it's own shell and I've tried using " EXECUTE
xp_cmdshell 'SUBST W:
\\network_server\shared\database\sql_serv...more >>
SSIS - Missing Source Files Posted by NR_TX at 7/9/2007 6:20:01 PM I want to skip running the SSIS data flow task when the source file is
missing. We have a scheduler that copies the source file to the staging area.
This SSIS package runs as SQL server job. So when a SSIS package fails due
to missing file the remaining steps in the SQL scheduler won't execut...more >>
Debugging Packages (all packages are opening) Posted by Jason at 7/9/2007 9:56:04 AM hello, how come when I debug the package I'm working in, all of the packages
in the solution are opened? How do I prevent this from happening?
Thanks,
Jason ...more >>
How to find the log of DTS run package Posted by Jack at 7/9/2007 8:56:03 AM Hi,
I am running a dts package. Where can I find the log of the dts package just
run. I am curious to see the log of the dts package especially if there are
errors that will prevent all data to be imported. In that case I will be able
to analyze the errors for the data that does not get impor...more >>
Where do I save SSIS packages to, to scehdule them? Posted by Paul at 7/9/2007 2:48:00 AM Hi,
Please only reply if you are answering my question, otherwise start your own
thread.
I can't find the locations, shown in the list, in the scheduled task, on the
SQL server. Could someone tell me exactly where they are?
Ta
Paul
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |