SSIS & Environment Variables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS & Environment Variables

43 posts, Page 3 of 5

«««1 2 3 4 5 »»»

SSIS & Environment Variables

Rate Topic

Display Mode

Topic Options

Author

Message

John Mitchell-245523

Posted Friday, January 11, 2013 1:56 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:35 AM
Points: 4,422, Visits: 7,180

If Column1 is bit, it won't be an empty string. It'll either be 1 or 0 or NULL.

John

Post #1405824

RVA Jeff

Posted Friday, January 11, 2013 7:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 18, 2013 11:40 AM
Points: 7, Visits: 32

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.

Post #1406003

nishav2

Posted Friday, January 11, 2013 10:29 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

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.

Post #1406170

nishav2

Posted Friday, January 11, 2013 10:29 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

Post #1406171

nishav2

Posted Tuesday, March 12, 2013 6:21 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

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.

Post #1430166

RVA Jeff

Posted Wednesday, March 13, 2013 7:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 18, 2013 11:40 AM
Points: 7, Visits: 32

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.

Post #1430390

nishav2

Posted Wednesday, March 13, 2013 7:55 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

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.

Post #1430395

Brandie Tarvin

Posted Wednesday, March 13, 2013 8:21 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 6,654, Visits: 5,675

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 Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1430419

nishav2

Posted Wednesday, March 13, 2013 8:28 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

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

Post #1430426

RVA Jeff

Posted Wednesday, March 13, 2013 8:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 18, 2013 11:40 AM
Points: 7, Visits: 32

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

Post #1430427

« Prev Topic | Next Topic »

43 posts, Page 3 of 5

«««1 2 3 4 5 »»»

Permissions