|
|
|
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 export to flat file - text qualifier or row delimiter problem when importing into excel Posted by -D- at 6/7/2007 3:52:21 PM I'm exporting using a query to a flat .txt file. The problem I'm
encountering is when I import the .txt file into excel, some columns cause
line breaks to the next row. The columns that are breaking to a new row are
varchar fields where the user has entered text using double quotes " within
...more >>
migrate dts to SSIS Posted by Mike at 6/7/2007 2:27:30 PM I already converted over several databases to SQL 2005 (i'm still running
them under sql 2000) for testing. Now I need to convert several DTS packages
that are on my SQL 2000 Server to my SQL 2005 server.How do I go about doing
this without creating everything again from scratch?
...more >>
DatePart in a DTS Posted by jmawebco at 6/7/2007 6:40:29 AM Can someone tell me how to make "fixDate" in the script below be equal
to Now() minus one day so that it is equal to yesterday?
I am using the Funtion shown below to locate a file in a remote ftp
server which has a name ending with a date value in yyyymmdd format.
The problem I have is that wh...more >>
2000 dts running on SQL 2005 Posted by Sue at 6/7/2007 3:38:01 AM I'm getting the following error when I tried to run a dts under 2005. (I did
get the sql server 2000 dts designer components downloaded)-CANNOT INSERT THE
VALUE NULL INTO COLUMN 'ID' COLUMN DOES NOT ALLOW NULLS. We have the ID as
an identity, so there is always values. What should I do, to ...more >>
SSIS Question Posted by SAM at 6/6/2007 7:12:02 PM Does anyone know or can provide an example of how to use
SQLSourceType: Variable in Execute SQL Task Editor
and
SQL command from variable in OLE DB Source Editor?
...more >>
SSIS Posted by SAM at 6/6/2007 6:48:00 PM Does anyone know or can provide an example of how to use
SQLSourceType: Variable in the Execute SQL Task Editor?
I selected a user variable that I created in the package but I am not sure
how it will use it or why I am getting an error message.
Also, an example on how to use
Data acces...more >>
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Posted by antonio at 6/6/2007 4:47:12 PM After deploying my SSIS package into our production server running what I
think is a 64 bit version of SQL Server Integration Services, I am unable to
execute the package. During validation I get the error:
Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
.....etc.
...more >>
Multi - Database Copy/Append Posted by Tiger at 6/6/2007 3:19:40 PM Hi All
Question for all
Im currently working on creating a Datawarehouse but am curious to
what the most effective way to accomplish this task with. Here is the
situation:
2 Servers (Server A and Server B)
Server A has X databases
Server B has 1 database
Each night, I need to copy ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
converting from 2000 dts to 2005 Posted by sue at 6/6/2007 12:22:01 PM When I tried to run a dts on 2005 that was migrated from 2000 server, I get
the following error:
cannot insert the value null into column 'id' column does not allow nulls
what do I do now?
thanks
Sue...more >>
SSIS and Transactions Posted by C at 6/6/2007 8:37:02 AM Can you enlist a Transaction withing the SSIS Designer or does this have to
be done via TSQL?
How do you handle Transactions in your SSIS Packages?...more >>
SSIS project migration Posted by mvp at 6/6/2007 6:38:02 AM Hello Everybody,
I have SQL SERVER SSIS project developed in my development server.
Now I have to migrate project to QA server (basically all the SSIS packages)
so that I can run all the packages from batch file from QA server.
In the developement server, I have 3 datasource connections.
So ...more >>
Flat file connection in SSIS Posted by Dora Manjula. at 6/5/2007 12:33:02 PM I have a delimited text file that has data which looks like this:
"INV_CLS","LD_DT",
"2","2007-06-01"
"2","2007-06-01"
"2","2007-06-01"
This worked perfectly in DTS. (comma delimited, " text qulaifier, {CR}{LF})
However, for the same file, SSIS is unable to parse the file. How do I get
a...more >>
File Watcher Posted by Sachin Chavan at 6/5/2007 1:57:00 AM Hi,
I need your thoughts on how to accomplish following task:
I have some SSIS Packages which processes files created or modified in a
perticular folders.
Now I dont want these Packages to be running continuously n keep monitoring
those folders (each package has its own folder to watch...more >>
SSIS and @@Identity Posted by Scott at 6/4/2007 4:53:01 PM Is there anything like @@Identity available in SSIS? I need to store the
identity value for a very large partitioned table for the switch from the
staging table.
Thanks,
Scott Mescall...more >>
SSIS isDate() function? Posted by appdevtech at 6/4/2007 12:09:03 PM I need to import char(10) strings that are formatted like this:
2007-06-14
2007-02-29
2007-06-22
2007-05-15
2007-05-22
1700-01-1
Please note that one of the dates is blank, not NULL and there is one date
not valid in SQL.
I need to validate they are valid dates and insert t...more >>
How are you documenting your ETL processes Posted by GreenHillCourt at 6/1/2007 10:27:00 PM
I'm currently using SSIS on a fairly large project. I wanted to know how
other developers are documenting their ETL processes. I've started using
Visio for flow charting some of my ETL processes. But I am finding it
difficult to use.
So, What tools/products are you using and are they workin...more >>
ForEach Loop Container Question Posted by Bob at 6/1/2007 11:21:46 AM I have a container that loops through files in a directory
and performs tasks.
It completes successfully even if no files are found so the
on Fail constraint does not trigger my sendmail task.
the Execution Results tab simply shows a warning.
Warning: The For Each File enumerator is empty.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |