|
|
|
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 Importing tables from Access to SQL Server Posted by Shane Jones at 9/28/2007 10:31:56 AM I've inherited a project which has numerous fields that have extra spaces in
them -- this is causing a problem with data Inserts, Edits, and Deletions in
my .ASP Website.
I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need
to know if there's a way that I can Right Tr...more >>
Script Task & Scripting.FileSystemObject Posted by Rmoore at 9/28/2007 8:41:01 AM I am tring to convert an existing ActiveX task to a Script Task using VB.net.
Below is the code from ActiveXScript (SQL 2000)? What will be the equivlant
in SSIS (Script task)?
Dim FSO
Dim InputFile
Dim InputFile2
Dim OutputFile
Set FSO = CreateObject("Scripting.FileSystemObject")
FSO.C...more >>
Why does Userid appear to change in DTS ? Posted by rmcompute at 9/28/2007 5:04:00 AM We run a scheduled job with Owner: SvcExePUser. In the log after the job
completes, it appears to run as US\svcClus as listed below:
Executed as user: US\svcClus. ...OnStart: DTSStep_DTSExecutePackageTask_1
One of our scheduled jobs keeps failing because the directory it is
transmitin...more >>
Passing parameter to Teradata Posted by Ashish at 9/28/2007 3:21:01 AM Hi,
I am writing a DTS package to get data from Teradata. It seems like Teradata
driver does not support parameters. I need to pass parameter to the query.
Is it possible to write ActiveX to substitute query parameters from global
variables?
Please give me the steps how to do it. Also, should...more >>
Checkpoints not saving variables Posted by Jason at 9/27/2007 3:25:00 PM Hello, If I have to restart an SSIS package at the checkpoint, how do I keep
my variable values? Is there a way to persist the variables in the
checkpoint files so when the package restarts, it knows what variables were
written too in an earlier task?
Here's my problem, if step A writes ...more >>
Source Excel's null value overrides destination table column default value Posted by michaelt at 9/27/2007 11:33:07 AM Using SSIS 2005, I am importing an excel worksheet whose column c
(formatted as number) has some null values. The destination table
column "c" (datatype of float) has a default of 0.
After executing the SSIS package, there's are NULL values instead
0's. Why is this? Is there a package confi...more >>
cannot convert between unicode and non-unicode data types Posted by cindy at 9/27/2007 10:46:00 AM I am converting a simple (at least in the SQL Server 2000 DTS days) to this
new SSIS. I have a data source (which is Oracle 8 using .Net ODBC provider)
and am trying to pump the data into a SQL Server table. I get an error that
it cannot convert between unicode and non-unicode data types. A...more >>
Transfert DTS Packages Posted by Cy at 9/26/2007 7:03:10 PM Newbie question. What is the easiest method of transfering DTS
packages between servers that cannot see eachother?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DTS / COM puzzle Posted by earthStrapped at 9/25/2007 8:08:01 AM I am having a puzzling problem with a DTS package in SQL 2000 that uses a
combination of "Execute Process Tasks" and "ActiveX Script Tasks." The issue
occurs with one of (the second) the ActiveX Script Task. The script invokes
a COM object that was written in C#. This COM object connects to...more >>
Execute Process Task timing out Posted by Karl Hoaglund at 9/23/2007 10:19:15 AM Hi!
I'm calling a VB.net exe using an Execute Process Task and it appears
to be timing out on me. It runs for 3 or 4 minutes and then just
stops and returns an error 128. I think it is timing out because 1)
if I run the exe directly it finishes completely without an error, 2)
the program do...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |