|
|
|
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 Maintenance Plan Posted by Audrey Ng at 10/5/2007 12:14:26 PM Good afternoon,
I have just deployed four SSIS packages to the MSDB database.
Unfortunately, when I deployed, the packages were not in the order that
I wanted them to be in.
(1) How do I re-order my packages?
(2) What is the purpose of the Maintenance Plan folders under the MSDB
folder?
...more >>
Importing from Excel Posted by dataGirl at 10/5/2007 9:42:01 AM Hello,
We just recentely upgraded to SQL 2005 and I'm having trouble with the
Import/Export wizard failing to insert data into my guid columns. A new guid
is supposed to be inserted when a new record is created, but this insn't
happening in 2005. In 2000, I would ignore the guid column in ...more >>
IBM OLE DB Provider for DB2 Posted by Borf at 10/4/2007 12:34:42 PM I am using the IBM OLE DB Provider for DB2 from SQL Server Integration
Services. I can connect and read the DB2 tables with no problem.
My issue is that I can not get it to work as part of a transaction.
Has anyone done this? is it even possible?
Thanks
Borf
...more >>
Powerful server takes more than 30 minutes to run DTS package Posted by Devious Devil at 10/4/2007 12:54:00 AM Hi,
Problem Context:
I have a group of related DTS packages each one produces a single CSV file.
I have another DTS package which calls each of the related group one after
another to genereate all the files in one go. The DTS packages are run via a
stored procedure that calls xp_cmdshell th...more >>
Available Input columns on Lookup not available Posted by dba at 10/3/2007 4:19:06 PM When I tried to use the Lookup the checkboxes are not displayed on the
Available Inputs they are on Available Lookups, I thought it was a
datatype missmatch so I pumped it through a data conversion before
hand so both sides are varchar(25) trying to do a lookup on State.
Still same problem, anyb...more >>
Append Data to Existing table daily Posted by Matt Williamson at 10/2/2007 2:00:28 PM I've been given a task and I'd like to get some feedback as to the best way
to accomplish it. I have a table that is historical data from an old system
that stays static. Everyday, I need to export a csv file from a new system
and append it to the static table for all entries after a specified...more >>
remove TXT file using DTS package Posted by FAHIM at 10/2/2007 7:34:10 AM any idea how to delete the physical file (C:\Test\file.txt) using DTS
package.
...more >>
DTS package will execute OK but Job will fail Posted by FAHIM at 10/2/2007 6:37:28 AM I have DTS package, that will import TXT file to SQL Table, it works
fine when I execute package manually, but it fails when I put it on
Schedule or Run through Job (Start the Job). No Error information,
except, it says, job was failed.
Any idea.
Thanks,
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Joining tables from different server in DTS Posted by sharancs NO[at]SPAM gmail.com at 10/2/2007 3:25:27 AM Hi,
Can any one please let me know how i can join a table in one server
with a table in another server using DTS. The result from the SQL that
contains this join condition will be transformed to another table in
one of the servers.
Regards,
Sharan
...more >>
SSIS package reads in MS Access memo column? Posted by mscertified at 10/1/2007 3:35:00 PM Has anyone successfully input an MS Access memo column into a SSIS package. I
need to have this be a fixed length file and truncated to 2000 characters. I
am having trouble with the data type which defaults to DT_NTEXT. How do I get
this data into a fixed width column with the truncation. I've...more >>
Date format Posted by FAHIM at 10/1/2007 12:46:00 PM HI friends,
Using SmallDateTime in SQL Table, how can I enforce M/DD/YY format on
column of type smalldatetime in SQL ServerDB.
What happening is that SQL convert this to YYYY-MM-DD, when my DTS
package brings data to table?
Note : output of DTS package is MM/DD/YY format.
Thanks...more >>
SSIS problems Posted by mscertified at 10/1/2007 11:26:04 AM No idea if this is the right forum for this - could not find an SSIS forum
anywhere.
I'm working with this for the first time and finding it very weird. Nothing
seems to work intuitively. I'm trying to set up a simple package and it is
taking hours. I'm using VS 5.
I have a data flow whi...more >>
SQL Execute Task +table input parameter? Posted by christof at 10/1/2007 12:00:00 AM Hello,
Is it possible to pass a result of one select from SQL Execute Task to
another one?
I have a scenario (lets name SQL Execute Task SET to simplify):
1) SET1 is a long duration SELECT and executes a function that returns
me a one column (COL1) table
2) I use the result to foreach contai...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |