Agree it's a good question, but poorly worded.

have you looked at either of these links

http://blogs.msdn.com/b/sriramg/archive/2010/06/03/moving-filestream-data-to-new-location.aspx

http://www.mssqltips.com/sqlservertip/1878/how-to-detach-and-attach-a-sql-server-filestream-enabled-database/

Exactly, you can pull the example apart see how it works -- comment things out, add new elements -–all while you’re learning.

look at this link - might not be exactly what you want, but a good place for yout to start

http://www.sqlservercentral.com/scripts/Data+Dictionary/72048/

by Abdullah.Khan

this link was helpful to me

http://www.mssqltips.com/sqlservertip/1443/integration-services-script-task-to-dynamically-build-package-variables/

You can retrieve data from a stored procedures with multiple input parameters

Attunity data connector are only supported on Enterprise version of SQL Server per Microsoft

In sql 2008 the Attunity data connectors were a separate download for Oracle & Teradata

and designed to...

When you say "But doesnot run when executed in Job Agent or when executed from outside BIDS"

what is the error message?

It would also be helpful to know

Have...

Agreed, that is my experience as well

So if you have eliminated the differences between Enterprise and Standard then check the differences between permissions of your account in BIDS and SQL Server Agent.

Have you grant db_ssisOperator or...

There can be several things contributing to your package not executing in you production environment from the Job Agent the two most likely are

- permissions- the job agent does not...

the following link was helpful in resolving a similar issue

http://blogs.msdn.com/b/psssql/archive/2009/02/02/why-aren-t-my-subscriptions-working.aspx

Yes you can transfer data from one server to another with an SSIS Package.

Would suggest creating the package with SQL Server 2008 BIDS and deploying to the SQL 2008 instance-

pulling...

Glad you resolved the issue

But not a bug in my opinion, bad design perhaps, if I'm understanding your post correctly.

This is how SSIS Configurations have worked since 2005 version.

When you...

If you highlight the project in BIDS Solution Explorer

then Right click on the project

in the drop down list select Properties - which opens project property pages

Run64BitRuntime is under...