You can't. That was what I was trying to explain.

You can't use variables/parameters directly in your OLE DB Source. You need to create a variable, construct your SQL statement there...

16 digits before the decimal separator, that sure is a lot of money 🙂

(I guess you have already solved the problem, as the statement that you provided should work)

siddforuall (11/16/2010)

---

Sure.!! I haven't started to move the packages yet to SSIS as I do not know the procedure yet. I just used upgrade advisor to check what changes will...

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...

The word itself explains it all: nothing is saved.

Change the package protection level to something else:

encrypt sensitive with userkey or encrypt sensitive...

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...

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...

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...

Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. 🙂

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...

parthi-1705 (11/18/2010)

---

Hi All

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...

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...

SanDroid (11/18/2010)

---

da-zero (11/18/2010)

---

We would prefer your respect for the effort that the author has made to create a question so that people could learn about compression, instead of calling it...

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

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

(first google result for ssis how to use xml config file)