|
|
|
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 Learning curve Posted by WebMatrix at 3/30/2007 10:38:03 AM I need to setup a process that would pull data from different source, compare
it to "local" SQL Server 2005 database resolve and update data differences.
So, I started new SSIS project, hoping I can figure out things as I go,
that's how I learned DTS after all. But I am totally lost.
How bad...more >>
Making Decision from within Package- HELP Posted by Cam at 3/30/2007 8:50:03 AM SQL Server 2005 Integration Services with Visual Studio 'Integration
Services' project.
I need the ability to run a package on "Working/Banking" days. I created a
store procedure to look in a table to determine if the date passed (Today) is
a working day or not. It returns Y or N. I marke...more >>
DTS Pump Task failure 80040005 Code execution exception: EXCEPTION_ACCESS_VIOLATION Posted by julian_holliday NO[at]SPAM hotmail.com at 3/30/2007 4:36:23 AM Hi,
The tables are only partially loaded before the failure.
I'm using DTS to transfer 9 files from 1 ODBC source into 9 Sql Server
table.
However, to try and avoid these exceptions, I have only allowed 1 task
to be executed at a time (within the Package Properties).
I am not using any...more >>
Order of rows imported Posted by SteveH at 3/29/2007 10:04:00 PM If I use DTS to import a text file into a table that has an identity column
and then queried the table and ordered by the identity column, am I
guaranteed to get the rows back in the same order they appeared in my import
file.
I have tested this with a small file and it did, but not sure if...more >>
My ADO.NET 2.0 Provider doesn't work in SSIS Import Export Wizard? Posted by Simon at 3/29/2007 9:58:02 PM Hi,
I've written an ADO.NET 2.0 provider for our company's database and a Visual
Studio DDEX design time support proivder. Everything works well and the
documentation supplied on MSDN and samples were excellent.
However I can not figure out how to get the SQL Server Integration Services
to...more >>
Inserting to a Partitioned view in SSIS Posted by daniel_barkman at 3/29/2007 11:48:04 AM I have a Partitoned view that UNIONs 65 underlying tables with the same
schema. This was originally implemented in SQL 2000. I upgraded to SQL 2005
Standard Edition and am now trying to write an SSIS package to load data from
text files into these tables.
Since each file would load into on...more >>
Restoring DTS packages Posted by bmcons NO[at]SPAM msn.com at 3/29/2007 11:37:55 AM I am receiving the following error message in restoring and saving DTS
packages in SQL Server (SS 2000):
"Class not registered"
First time I have encountered this issue and will much appreciate
suggestion on how to fix.
...more >>
how to change transformations dynamically? Posted by Test Test at 3/29/2007 9:03:23 AM Can the transformations be changed "dynamically" during runtime? I plan
to set up a single package with two SQL server connections (source and
destination) with global variables (using dynamic properties task) for:
1) source server
2) target server
3) stored procedures (runs on the source ser...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS PAckage never completes Posted by A. Robinson at 3/29/2007 8:42:01 AM I am encountering a weird issue with SSIS.
I have a very simple SSIS package that executes a .bat file. Here's the
actual file it executes:
@Echo Off
c:
F:
cd ReportingServicesScripts
rs -i NoteBlankSnapshots.rss -S http://10.90.160.13/ReportServerTest
EXIT
The .bat file executes a R...more >>
How to view scheduled dts packages Posted by Peter from holland at 3/29/2007 12:52:02 AM Hello,
We designed a DTS package in our SQL server 2000 environment.
It executes fine, no problems so far.
When we schedule the package it works fine on the scheduled time.
But when we open the schedule tab at the specified package to view the
schedule it seem it resets to a daily cycle at 0...more >>
DTS adds extra character to EXCEL file Posted by kuidokylm via SQLMonster.com at 3/29/2007 12:00:00 AM Hello
I'm using SQL2000 DTS services to export stored procedure result to EXCEL
file.
When I open EXCEL file, all the data is prefixed with ' character like
'AAMURUSKO
'PIHKALANKATU
How to avoid that ?
Kuido
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |