|
|
|
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 Flat file text delimiter Posted by tjfdownsouth at 8/14/2007 8:12:01 PM I am using SQL2005 management studio to export the data from a table to a
flat file. If I include a text delimiter it adds it to every column, i have
checked the columns with the edit transforms button and some of them are
ints. Is there a setting that I am missing that needs to be enabled s...more >>
Using CASE with IN in WHERE clause Posted by rahulcheeku NO[at]SPAM gmail.com at 8/14/2007 7:33:52 PM I want to write the following condition in where clause
SELECT * FROM Cust_Data
WHERE Cust_ID IN (CASE WHEN Cust_No = 345 THEN 12,23,34 ELSE 56,67
END)
but i know syntactically it is in correct. I also tried it this way
WHERE Cust_ID IN (CASE WHEN Cust_No = 345 THEN (select ID From
Cus...more >>
Can't set SQL 2000 DTS package schedule Posted by Mike at 8/14/2007 6:18:01 AM Hi. If I right-click a SQL 2000 dts package and select Schedule, and then
specify a schedule of every one (1) hour and click ok, the next time I open
the Schedule window that setting is removed. When I reopen the Schedule
window the default setting of 'once a day at 12:00AM' is selected.
...more >>
Strange error when Executing an SSIS package from a SQL Job Posted by Hugh at 8/13/2007 2:26:23 PM Hi All,
I have searched the newsgroup and web for something that would answer this
problem but I haven't been able to find anything...
I have created an SSIS package using the "Import Data..." wizard to transfer
data from one database on the server to another on the same server. I am
sa...more >>
How do I import text file from remote location? Posted by ksbjr NO[at]SPAM yahoo.com at 8/13/2007 12:00:00 AM DTS makes it simple enough to import a text file from the local PC
(e.g., C:\MyFolder\MyData.csv) when running Enterprise Manager, but
how, exactly (step-by-step), do I go about getting that same text file
from a location other than the local PC using a scheduled DTS
package? Here are two scena...more >>
Why save SSIS using integrated security Posted by JXStern at 8/11/2007 9:55:41 AM Just looking (for the first time!) at the SSIS docs, they seem to
emphasize using integrated security if/when saving package to msdb.
Any idea why?
http://msdn2.microsoft.com/en-us/library/ms186803.aspx
So happens my current shop is not much on integrated security.
J.
...more >>
multiple variables Posted by Jeffrey Hornby at 8/10/2007 11:24:00 AM I'm having trouble passing package level variables into my script
transformation.
I'm fine as long as I pass only one variable in but as soon as I list two
variables I get the error
"The variable cannot be found. This occurs when an attempt is made to
retrieve a variable from the Variabl...more >>
SSIS utilitity Posted by Nash at 8/10/2007 12:00:00 AM I have SSIS(DTS) using the dataflow OLE db which query the database to
extract information for actions done yestarday. In the sql statement
i'm using calling the function DATEADD(dd, -1, getdate()) to extract
the yestardays information on a date field.
This package sends information in excel for...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Calling Stored Procedure in DTS Posted by TLuebke at 8/8/2007 2:50:02 PM newbie question: One step of a DTS package calls a stored procedure that does
a query that builds a table. (i.e. exec procedure name) next I want to run an
update on the table after the stored procedure is finished. Whats best?
1. put the update sql in the same step after the stored procedure...more >>
SSIs Data type Posted by Gayatri at 8/8/2007 1:06:37 AM Hi,
Can someone please let me know the size of data type - "String" in
SSIS package?
I tried to search for it but the documentation gives me the details of
data types DT_STR/DT_WSTR which are actually not available in SSIS
package.
Thanks in advance.
Gayatri Kulkarni
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |