|
|
|
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 DTS package that append data to the database Posted by qjlee at 4/7/2007 9:50:01 PM I have a dts package which copies data from one excel speadsheet to a SQL
database. How I can configure this package so that 1). the data will append
data to the database, or 2). truncate the data in the database and refresh
the new data.
Thanks, ...more >>
Please, I need help with importing from excel Posted by Al at 4/7/2007 6:30:02 PM I am new to SQL Server, and I am picking up a database in SQL server 2000.
The developer who built that database, created a DTS package to import data
from excel. In the package, there is an XL Connection and a SQL Server
connection and a blank line between the two going from XL to SQL Server. t...more >>
SSIS Variables in Execute SQL Task Posted by Jim at 4/7/2007 10:50:02 AM Hi - I have an SSIS package that loops through 36 Excel files and loads them
into a SQL table. I want to add a column to the table that contains the
filename. I was trying to update the table with the filename from the
varExcelName variable I used to enumerate the foreach loop, but can't see...more >>
_execution? Posted by maus2001 at 4/7/2007 12:00:00 AM Hi everybody
I have a couple of packages which have to be started manually. I wrote a little programm in VB that
can handle this. So far so good. I'm now looking for a way to give the users some feedback about the
progress of the package execution (as well as error-conditions). In SQL Server ...more >>
Help understanding SSIS ! Posted by Rob at 4/6/2007 12:00:00 AM Hi,
New to SSIS... I have created many dts packages in sql server 2000, but am
having a tough time understanding SSIS...
I know I need to do some learning... what is the best resource book ?
I know people are going to tell me to use dot net code as opposed to
vbscript when I ask my ques...more >>
SSIS: Is it possible to have "if then else" flow in Control flow? Posted by nkw at 4/5/2007 9:10:02 PM I have a Script Task and two Sequence Container. The Script Task will run one
of the sequence container depends on its interal logic at runtime.
Can SSIS do this? It does have a for/foreach, but no if/then/else.
Thanks....more >>
Help with data type Posted by Al at 4/5/2007 8:02:02 PM Ihave a DTS package in SQL that imports data from an excel spread sheet to
sql server table. on of these fields in excel has some cells formatted as
numbers and some formatted as text. the counter part field in the sql table
is formatted as char. as a result the only the cells that are formatt...more >>
Migrate DTS package Posted by Emma at 4/5/2007 11:28:09 AM What is the best way to migrate DTS packages from a 2000 server to another
2000 server?
I am currently exporting them one package at a time from a 2000 instance to
disk and then importing the file into the new server using 2005 Management
Studio. I have a lot of packages to migrate. Is there ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS Script Component Date Processing Posted by Jack Lenning at 4/5/2007 11:02:18 AM Hello,
I'm running into a problems when trying to process dates in an SSIS script
component.
The datatype coming into the asynchronous script component is a
DBType_DBTimeStamp, and I need to store the date in a local variable in the
script component, which is a DateTime datatype.(to comp...more >>
DTS package fails when run via Job Scheduler Posted by Josh at 4/5/2007 7:16:03 AM I have a DTS package that runs three times per week as a scheduled job via
SQL Job Scheduler (SQL Server 2000, SP4). There are no other jobs running at
the same time as my job.
The job has been failing lately when run via Job Scheduler (whether or not
it runs at its scheduled time or is st...more >>
Export to Excel with Custom Properties Posted by Red at 4/5/2007 6:00:33 AM Hi,
We have lots of DTS packages that output to Excel files. We would
like to add custom properties to the Excel files, such as the (DTS)
source of the file, DTS package version, Any global variables etc.
This would help us to identify the source of a file that has
circulated around the comp...more >>
ssis - intermittent problem Posted by GE at 4/5/2007 4:54:02 AM I have SQL server 2005 with Service
pack 2.
The problem is:
I get this intermittent problem either when I am loading a file into a
table or exporting a table into a text file.
I get this following error message:
[OLE DB Source [1]] Error: SSIS Error Code
DTS_E_CANNOTACQUIRE...more >>
Please help with DTS filter Posted by Al at 4/4/2007 6:46:02 PM I am new to SQL Server, and I am picking up a database in SQL server 2000.
The developer who built that database, created a DTS package to import data
from excel. It seems that he put a filter (constraint) to import only the
data that starts with FY. The rest of the rows does not get imported....more >>
DTS job error Posted by SQL Guy at 4/4/2007 11:24:01 AM Hi, I am getting the following error when a scheduled job fails.... I need
your help to understand this error message.
Thanks....
Executed as user: CORPORATE1\sqlservices. ...
DTSStep_DTSExecutePackageTask_3 DTSRun OnStart:
DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_...more >>
Reset Identity Fields or Foreach Ado.Net Schema Rowset Posted by Dinsdale at 4/4/2007 11:14:09 AM The end result of what I am trying to accoplish is this: I would like
to use SSIS to reset the identity fields on all tables where the table
name ends with _type. If someone has a better suggestion than what I
am currently trying, please feel free to suggest it. That said:
I am trying to use t...more >>
Need Assistance with Dynamic Properties and FTP Task Posted by cdun2 at 4/4/2007 3:32:01 AM Hello,
I am building a packge where an FTP task needs to pull down a single file
every day from a specific location. The location will only have the one file.
The file name will be different every day. A sample of one of the file names
looks like this:
CDNSC.CDNSC.SC00015.04012007
The...more >>
The DTS host failed to load or save the package properly Posted by Alien2_51 at 4/3/2007 3:20:02 PM I'm getting this error message "The DTS host failed to load or save the
package properly" on my MS SQL 2005 database instance with SQL 2000 DTS
Designer Components installed. I can open package versions not modifed by the
SQL 2000 DTS designer. I've done some research and found that others are...more >>
2 problems with SSIS DTS when trying to add record to entity lead of MS CRM Dynamics 3.0 Posted by Alex at 4/3/2007 12:00:00 AM Hello,
we need to execute a DTS in SQL Server 2005 that allows to migrate data from
Excel to the entity lead by CRM 3.0
there are a lot of records and columns so we don't want to use web services,
i have done 2 ssis dts with the purpose to insert records filling firstname
and lastname t...more >>
Initial value for a variable in a SSIS package Posted by Carly at 4/1/2007 9:22:43 AM Hi,
I have a SSIS package that is very simple.
It is a for loop that needs to run a SQL task a number of time until
the variable i becomes >5.
However the initial value of the variable i comes from a file -
written by another application... etc.
I am not sure how to read the initial value fr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |