Viewing 15 posts - 10,861 through 10,875 (of 11,676 total)
siddforuall (11/16/2010)
November 19, 2010 at 2:28 am
What is the exact error that you get?
It may be a long shot, but when I execute the code in your sp with an invoicenumber of 1000 I get the...
November 19, 2010 at 2:26 am
mklein2 (11/19/2010)
The protection level of my package is "DontSaveSensitive"
The word itself explains it all: nothing is saved.
Change the package protection level to something else:
encrypt sensitive with userkey or encrypt sensitive...
November 19, 2010 at 1:33 am
I think the easiest configuration (in SSIS) is this one:
* use a data flow
* in the data flow, use an OLE DB Source where you execute your stored procedure
* as...
November 19, 2010 at 12:05 am
Just to be clear, what do you exactly mean with custom .NET code?
Do you mean code in Script Task/Component, or do you mean a task/component that you have developed yourself...
November 18, 2010 at 11:59 pm
In SSIS, there are many ways to get to your goal. Choose the one you feel comfortable with (and preferably the most performant and scalable one). Don't forget that a...
November 18, 2010 at 11:53 pm
Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. 🙂
November 18, 2010 at 11:47 pm
Allright, I'm no design expert, but I'll do my best.
Q1: make your tables as small as possible. Meaning, for example, use varchar instead of char. Use int, smallint or tinyint...
November 18, 2010 at 1:58 pm
parthi-1705 (11/18/2010)
I think i has got the solution (not for sure) UNION ALL transformation under split and join transformations will be doing this type of work
The Union All...
November 18, 2010 at 1:46 pm
Glad that you found a working solution, Tim, but a small sidenote from Microsoft:
The ActiveX Script task is provided only for purposes of backward compatibility with the deprecated component, Data...
November 18, 2010 at 1:41 pm
SanDroid (11/18/2010)
da-zero (11/18/2010)
November 18, 2010 at 1:38 pm
Execute SQL Task: http://technet.microsoft.com/en-us/library/ms141003.aspx
Send Mail Task: http://technet.microsoft.com/en-us/library/ms142165(SQL.90).aspx
November 18, 2010 at 1:31 pm
http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm
(first google result for ssis how to use xml config file)
November 18, 2010 at 12:16 pm
If you want to store values in a variable with an Execute SQL Task, do the following:
* create a SSIS variable
* write your query in a Execute SQL Task. Make...
November 18, 2010 at 12:13 pm
It would be helpful if you posted the expression(s) that you use in the derived column.
For some reason, a row has some invalid data that makes the derived column fail.
November 18, 2010 at 12:07 pm
Viewing 15 posts - 10,861 through 10,875 (of 11,676 total)