|
|
|
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 package protection level Posted by Yuhong at 8/21/2007 1:34:02 PM Hi,
I have created a SSIS package and the protection level was set to
"EncryptSensitiveWithUserKey". I'd like to change it to "ServerStorage". But
when I try to save the package, I got the following error:
Failure saving package.
------------------------------
ADDITIONAL INFORMATION:
...more >>
Parsing EDI/X12 in SSIS Posted by JXStern at 8/21/2007 12:39:18 AM The good thing is we don't have to parse the raw EDI, we are getting
the data from a service that gives it to as us CSV files.
The bad thing is, within a single CSV file it's still hierarchical, so
we get data like:
head, a, v1, v2,,,,,
line, a, 1, v1, v2,,,,
comment, a, 1, t1,,,,,
line,...more >>
sql server 2005 failed to create integrations project Posted by Bob at 8/20/2007 9:44:22 AM Hi,
When I attempt to create a new Integrations Project I receive words to
the effect 'project integration creation failed'.
Under Vista, I have un-installed SQL Server 2005 and reapplied SP2 and
Vista fix.
Same results.
Any suggestions?
...more >>
Transform Data Task truncating a digit Posted by Jason at 8/20/2007 12:00:00 AM Hi
I'm trying to copy a table across from a Sybase ASE server to MSSQL
Server. I'm not doing any transformation logic on the data, I just
want to copy the table across.
The package runs ok, but I found that a particular field is missing a
digit when it comes across.
The datatype is money...more >>
Learning sql server 2000 Posted by Prem Mehrotra at 8/18/2007 11:26:03 AM I am an Oracle DBA. I want to learn SQL SERVER 2000 in depth (i.e.
become an expert SQL SERVER DBA). Can you point any artciles/books
which show mapping of terminologies from Oracle to SQL Server. I know
there are some artciles on Microsoft's web site, but looking for other
artcles as well. ...more >>
Is it possible in DTS Transformation Data Task Posted by pursew NO[at]SPAM gmail.com at 8/16/2007 1:31:47 PM Hi:
...more >>
Is this possible is Transform data task Posted by pursew NO[at]SPAM gmail.com at 8/16/2007 12:36:31 PM Hi:
I have a task that I need to retrive data from a table in teradata
database every month. However, the name of the table change every
month depends on the month.
For example, in Jul 07, it will be table_200707 and table-2007_08
in Aug 08.
...more >>
SSIS:how to arrange dtsx into different folder & offline setting problem Posted by YesGoGoGo at 8/16/2007 9:37:10 AM hi!
I have 2 questions about SSIS.
1.
In my SSIS project
there are many dtsx
can I arrange them into different folder?
like
SSIS_PROJ
|
---FolerA---DTSX1, DTSX2,DTSX3
---FolerB---DTSX4, DTSX5,DTSX6
I've tried to arrange these DTSX but failed.
I wonder if there is something like SSRS ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
XML Log (-> file size!) Posted by Frederik V at 8/16/2007 12:00:00 AM Hi everyone,
I'm asked to continue an existing project in SSIS, which currently uses XML
for logging. I noticed that we now have log files up to 200MB in size. Is
there a way to limit those log files in size?
Please do keep in mind that I'm still learning SSIS, so keep your answer as
...more >>
SQL Server does not exist or access denied Posted by sharman at 8/15/2007 9:12:07 AM Hi,
I am having a problem with a DTS in which I run SQL statements choosing
different connections. I have added a new Production server and I created a
new connection for that. Now whenever I try to run the step using the new
connection I get this error:
[DBNETLIB][ConnectionOpen (Connec...more >>
Clearing Out DTS Package Logs Posted by JDS at 8/15/2007 8:02:02 AM I have a sql server sp4 that has about 910 DTS packages with package logging.
I'm not certain if all the packages have package logging but many do.
The issue we are having is that these logs are beginnning to fill up the
msdb database. Is there a way to schedule a package, run a script,or is
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |