Thanks.

Are you using any expressions or package configurations that would affect where you think the Excel file will be?

:w00t:

I would edit the package and put in a script task prior to calling the stoired proc. Put a MSG box in the script task. Run the package the message...

I must be doing something really wrong this week. The Microsoft connection site will not allow me to self nominate. That made me a bit grumpy. I spent most of...

EncryptSensitiveWithUserKey -

I have just built some packages so have been looking at the security level. I can not find written proof that this is true but I suspect that...

Small talk in moderation can be good. If it helps to build a bond all the better. I was once interviewed by someone who used to play football (soccer dude)...

Is there a default value for the parameter in the stored proc?

What is the default value for the variable in SSIS?

Can you see what the value of the variable is...

You are executing the SSIS package from a SQL job. Are you executing the SQL Job on your laptop or on the server?

What is the package protection level in the...

or is the question -

how do i get current date i.e select getdate() ?

Ells.

😎

I ahve to admit all of my documentation is done in a word doc of the same name as the package. This can be placed in with the packages or...

not quite sure what what you are asking. The windows ID must be able to access the folder and read the file.

It looks like this os only the case when...

Created my own stored proc.

USE [PH_Datawarehouse]

GO

/****** Object: StoredProcedure [dbo].[sp_dts_addlogentry] Script Date: 08/24/2009 14:51:02 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_test]

AS

IF 1 =...

Should have said 5mb per file limit. BUT there is a fabulous utility called Chainsaw this will chainsaw your file into whatever size chunks you want and produce a bat...

Windows live Sky Drive.

25GB of space and all you need is a windows live login. Whats on there is all my notes, scripts, projects, docs and a list of...

I dont quite understand what you have done. Could you take a screen shot of the control flow tab and data flow tab and add those as an attachmnet and...

have you tried different options under the impersonation tab of the data source. Mine is currently set to use the service account

Ells.

:w00t: