Hey this setup is for packages on file system right?

I found an interesting way to run the package in a Job. Instead to select the SSIS Package on the Job...

The connection is configured. The password worked.

I found the problem, My package was with PROTECTION LEVEL "Dont Save Sensitive". I changed it to "EncryptSensitiveWithUserKey" and it works...

I found SSIS...

I didnt change any destination property:

I just changed the Flat File Connection properties Expression like:

"\\\\prohhreport\\reports\\stbinfo-"

+ (DT_WSTR,4)YEAR(dateadd("dd", -1, GETDATE()))

+ RIGHT("0" + (DT_WSTR,2)MONTH(dateadd("dd", -1, GETDATE())), 2)

+ RIGHT("0" + (DT_WSTR,2)...

I found the expression,now I know how to set it up. It takes exactly the file name that I need.... But, I got another issue when I added this expression.

In...

Hi,

Thank you for your help. Where can I select the expression builder ?

my stored procedure has some join tables (including the staging table) to populate the destination table... Can...

Hi,

Now its working. But, in the path I have around 1000 files, I just need the process to take the new one to load the data of the day.....

Hi,

i did it but my original connection was broken. My OLE DB Destination has the name of the Server, user, password and database specified. When I added the variable...

Hi,

Im sorry for the delay. I just want to comment that I was looking at development database when I mentioned the simple recovery model... My production database is on...

Im sorry, I guess I wasnt clear enough.

i just need to see what processes (queries, sp, etc) are running right now.

thank you

You are right.. I have a Simple Recovery Model and my logs backup every hour.. Im confuse because I got this information in a Microsoft Training. In this case,...

Thank you so much,

forgot that little detail 😉

Have a nice day 🙂

Thank you for your advice..

Im getting the same time, but the second query help me to get the info a little faster but, with less information...

anyway!! I guess the...

these 2:

selectdistinct t1.Date, t2.MacAddress

fromTABLE1 t1

joinTABLE2 stb on t2.Id = t1.Id

wheret1.Date between '2009-03-01' and '2009-03-30'

selectt1.MacAddress, t2.date, t1.Id

fromdbo.Table1 t1

joindbo.Table2 t2 on t2.Id = t1.Id

WHEREt1.Id not in

(select t2.Id

from Table2 t2

where...

What you are trying to accomplish may not benefit from a partitioned table. What is your objective? How much data do you have? What are the normal queries that are...

PARTITION FUNCTION

CREATE PARTITION FUNCTION pf_NAME (datetime)

AS RANGE RIGHT

FOR VALUES

(

'2008-01-01 00:00:00.000'

,'2008-02-01 00:00:00.000'

,'2008-03-01 00:00:00.000'

,'2008-04-01 00:00:00.000'

,'2008-05-01 00:00:00.000'

,'2008-06-01 00:00:00.000'

,'2008-07-01 00:00:00.000'

,'2008-08-01 00:00:00.000'

,'2008-09-01 00:00:00.000'

,'2008-10-01 00:00:00.000'

,'2008-11-01 00:00:00.000'

,'2008-12-01 00:00:00.000'

,'2009-01-01 00:00:00.000'

,'2009-02-01 00:00:00.000'

,'2009-03-01 00:00:00.000'

,'2009-04-01 00:00:00.000'

,'2009-05-01 00:00:00.000'

,'2009-06-01 00:00:00.000'

,'2009-07-01 00:00:00.000'

,'2009-08-01 00:00:00.000'

,'2009-09-01...