Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS & Environment Variables


SSIS & Environment Variables

Author
Message
John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7502 Visits: 15160
If Column1 is bit, it won't be an empty string. It'll either be 1 or 0 or NULL.

John
RVA Jeff
RVA Jeff
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 84
Yeah, I'm kinda confused too.
So you have an inbound column of datatype Char(1) or something character based? And you want to derive a new column from that which will be of type BIT? First I don't think you can have a null BIT value.. but I could be wrong on that, I dunno why one would want a null BIT...

In any event, this message and forum isn't the right place for your question.
Start a new thread, include in the subject something about "SSIS Expression Language".
Your question will get more attention that way.
Post a link to it in this thread. I'll poke around w/ your idea and if I come up w/ something I'll respond to your new post. No promises.
nishav2
nishav2
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 103
LTRIM(column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252) : (column1) == "Y" ? (DT_STR,100,1252)1 : (DT_STR,100,1252)0

I finally arrived at the correct derived column expression.

Let me brief on this.
I am pulling the data from text file and dumping it into sql table.
So when loading column1 value from text file to sql table it should be loaded under BIT datatype.
So that why i have added the above expression to that column.

Hope this would help someone ....
Thanks for your reply. If i come across this kind of issue i will start a new thread.
nishav2
nishav2
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 103
LTRIM(column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252) : (column1) == "Y" ? (DT_STR,100,1252)1 : (DT_STR,100,1252)0

I finally arrived at the correct derived column expression.

Let me brief on this.
I am pulling the data from text file and dumping it into sql table.
So when loading column1 value from text file to sql table it should be loaded under BIT datatype.
So that why i have added the above expression to that column.

Hope this would help someone ....
Thanks for your reply. If i come across this kind of issue i will start a new thread.
nishav2
nishav2
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 103
1) I created an Integration service project

2) I created a common connection Manager for that project.

3) By sharing the same connection manager many number of packages exist under that project.

4) Now I need to set up the package configuration at project level.So that I do not need to go and enable the package config for every single package.



Please suggest.
RVA Jeff
RVA Jeff
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 84
I've never tried it, but if your shared connection has the same name in each package, you should be able to create a single Package config in each package of the project using the same Configuration filter for each. Does that make sense?

Or maybe use a single configuration file for all packages in the project. I don't use config files, so maybe that doesn't work.
nishav2
nishav2
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 103
Jeff Thanks for your reply. Yeah all my packages use the same connection.But I am not able to create a sql server config because it throws an error saying this package path is not found.
Brandie Tarvin
Brandie Tarvin
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7821 Visits: 8752
Please be more detailed on where the error is coming from and what the error says.

What type of configuration are you trying to create? (XML, Table, etc.) and where in the creation process does it complain about not being able to find the package? And what exactly is the error message (every word, please).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
nishav2
nishav2
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 103
I want to set up SQLTable package config.
1) I established a source(Source_DB) and destination (Destination_DB) connection (OLEDB connection) at connection manager level.
2) So those two connections are shared across all the packages under the solution.
3) Next I opened one of the package to set up table level package config.
4) The package config was saved successfully.
5) But when I clicked on EDIT package config it throws me an error saying 'This package is not laoded successfully.Because the package path is not available in the (Source_DB) and the package path is not available in (Destination_DB). I will send you the exact error details soon.

Thanks
RVA Jeff
RVA Jeff
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 84
Is your connection named the same in each package? Table configs are referenced by name in the table.
Try creating a table config in each of your packages that is strictly for this one connection. Don't put any others properties in it.

You could also try using an Environment variable. Not a very versatile package config as you can't change its value too often (ie w/o reboot). But that may be a good option, depending on your needs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search